SET TRANSACTION and SQL Standard

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: SET TRANSACTION and SQL Standard
Date: 2008-12-31 18:27:10
Message-ID: 1230748030.4032.78.camel@ebony.2ndQuadrant
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I notice that we allow commands such as

SET TRANSACTION read only read write read only;

BEGIN TRANSACTION read only read only read only;

Unsurprisingly, these violate the SQL Standard:
* p.977 section 19.1 syntax (1)
* p.957 section 17.3 syntax (2)

Not planning on fixing it myself, but others may wish to.

--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2008-12-31 18:41:00 Re: Latest version of Hot Standby patch
Previous Message Tom Lane 2008-12-31 18:25:34 Re: version() output vs. 32/64 bits