Re: SET TRANSACTION and SQL Standard

On Fri, 2009-01-09 at 16:14 +0200, Peter Eisentraut wrote:
> Simon Riggs wrote:
> > 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)
> 
> Well, we allow a lot of things.  Violations of the SQL standard happen 
> when a command that appears in the standard doesn't do what the standard 
> says.  Allowing commands that are not in the standard is not a violation.

Except when the standard explicitly forbids it, as with the above.

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