> That is not the correct syntax. Use SAVEPOINT, then ROLLBACK TO SAVEPOINT > or RELEASE SAVEPOINT. postgres log file: 2006-01-26 21:45:59 LOG: statement: INSERT INTO dok ..... 2006-01-26 21:45:59 ERROR: insert or update on table "dok" violates foreign key constraint "dok_klient_fkey" 2006-01-26 21:45:59 DETAIL: Key (klient)=(ESTATEINVEST) is not present in table "klient". 2006-01-26 21:45:59 STATEMENT: INSERT INTO dok ........ 2006-01-26 21:45:59 LOG: statement: ROLLBACK <-- this statement seems to be generated automatically by Microsoft Visual FoxPro or by Postgres ODBC driver 2006-01-26 21:45:59 LOG: statement: ROLLBACK TO savepoint copyone 2006-01-26 21:45:59 ERROR: ROLLBACK TO SAVEPOINT may only be used in transaction blocks My client application (Microsoft Visual FoxPro 9) seems to generate automatic ROLLBACK statement in case if one of its commands (APPEND FROM TABLE) fails I have'nt found a way to disable this ROLLBACK So I'm looking a way to force Postgres to ignore this ROLLBACK Andrus.
