You can use savepoints in pg 8.0:
http://www.postgresql.org/docs/8.0/static/sql-savepoint.html
Surabhi Ahuja wrote:
in a transaction i try to insert into a table1, followed by insert
into table 2 then insert into table 3 and last insert into table 4.
However if a unique key violation occurs in the table 1 , the whole
trabnsaction aborts. is there no way , where i can ignore this
violation, and continue with the remaining insertions.
?
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
