> 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.