Horton

Re: Multiple Xids in PGPROC?

Simon Riggs <simon@2ndquadrant.com>

View thread View on postgr.es
From: Simon Riggs <simon@2ndquadrant.com>
To: Rod Taylor <pg@rbt.ca>
Cc: Christopher Kings-Lynne <chriskl@familyhealth.com.au>, Bruce Momjian <pgman@candle.pha.pa.us>, Alvaro Herrera <alvherre@dcc.uchile.cl>, Hackers <pgsql-hackers@postgresql.org>
Date: 2004-05-05T22:07:33Z
Lists: pgsql-hackers 
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