Thread: SET TRANSACTION conformance to SQL:2003
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. Docs page updated. Manual tests OK. There isn't a test suite for SET TRANSACTION, so I haven't created one just for this. Behaviour is shown below; the SET command sets the session characteristics of the *next* transaction, when executed outside of a transaction block. postgres=# show transaction_read_only; transaction_read_only ----------------------- off (1 row) postgres=# set transaction read only; SET postgres=# begin; BEGIN postgres=# show transaction_read_only; transaction_read_only ----------------------- on (1 row) postgres=# commit; COMMIT -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com
On Fri, 2007-09-07 at 14:00 +0100, Simon Riggs wrote: > Short patch -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com
Attachment
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 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.
>
> Docs page updated.
>
> Manual tests OK. There isn't a test suite for SET TRANSACTION, so I
> haven't created one just for this. Behaviour is shown below; the SET
> command sets the session characteristics of the *next* transaction, when
> executed outside of a transaction block.
>
> postgres=# show transaction_read_only;
> transaction_read_only
> -----------------------
> off
> (1 row)
>
> postgres=# set transaction read only;
> SET
> postgres=# begin;
> BEGIN
> postgres=# show transaction_read_only;
> transaction_read_only
> -----------------------
> on
> (1 row)
>
> postgres=# commit;
> COMMIT
>
>
> --
> Simon Riggs
> 2ndQuadrant http://www.2ndQuadrant.com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +