On Wed, 2004-05-05 at 05:30, Rod Taylor wrote: > Yup.. And some of us intend on wrapping every single statement in a > subtransaction so we can rollback on an error without aborting the main > transaction. >
That is exactly what is needed to achieve full Oracle & DB2 compatibility. I suggest that this should be a session settable parameter, to allow session transaction semantics to mimic particular DBMS. I want the behaviour but not the effort... Best Regards, Simon Riggs ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster