Re: [PATCHES] SET TRANSACTION conformance to SQL:2003

2007-09-14 Thread Bruce Momjian
This has been saved for the 8.4 release: http://momjian.postgresql.org/cgi-bin/pgpatches_hold --- Simon Riggs wrote: > Short patch to implement SQL standard behaviour of the SET TRANSACTION > command. According to t

Re: [PATCHES] SET TRANSACTION conformance to SQL:2003

2007-09-07 Thread Simon Riggs
On Fri, 2007-09-07 at 14:00 +0100, Simon Riggs wrote: > Short patch -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com Index: doc/src/sgml/ref/set_transaction.sgml === RCS file: /projects/cvsroot/pgsql/doc/src/sgml/ref/set_t

[PATCHES] SET TRANSACTION conformance to SQL:2003

2007-09-07 Thread Simon Riggs
Short patch to implement SQL standard behaviour of the SET TRANSACTION command. According to their publically accessible docs, I note that MySQL and Ingres correctly implement this behaviour, SQLServer does this also (and more), while Oracle and DB2 do so since they use implicit transaction blocks.