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 <systemguards@gmail.com> 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
>