One more question comes to mind. IIRC, Oracle doesn't need you to rollback the whole transaction if one statement fails (like constarint violation in this case)!!! Does the standard dictate that an error in a transaction should force a rollback?
I could be wrong about Oracle; I do not have an Oracle installation to check, can somebody verify this? Regards, Gurjeet. On 5/21/06, Jaime Casanova <[EMAIL PROTECTED]> wrote:
there was a thread about that two months ago... here's Tom's response: http://archives.postgresql.org/pgsql-hackers/2006-03/msg00786.php
---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
