Re: SET TRANSACTION and SQL Standard - Mailing list pgsql-hackers

From Tom Lane
Subject Re: SET TRANSACTION and SQL Standard
Date
Msg-id 26239.1231518040@sss.pgh.pa.us
Whole thread Raw
In response to Re: SET TRANSACTION and SQL Standard  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: SET TRANSACTION and SQL Standard  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
Simon Riggs <simon@2ndQuadrant.com> writes:
> "If any condition required by Syntax Rules is not satisfied when the
> evaluation of Access or General Rules is attempted and the
> implementation is neither processing non-conforming SQL language nor
> processing conforming SQL language in a non-conforming manner, then an
> exception condition is raised: syntax error or access rule violation."

> If we *choose* to be an SQL implementation that conforms to the SQL
> standard, then it should throw an error. 

That reading would forbid any nonstandard syntax whatsoever...

What this is actually describing is the "standards conformance checking"
mode that the standard says you ought to provide, but we never have
(nor have most other vendors AFAIK).  In SQL92 this was described as
a "SQL Flagger" and it was optional.  Not sure what the latest spec
says about that.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Aidan Van Dyk
Date:
Subject: Re: Improving compressibility of WAL files
Next
From: Tom Lane
Date:
Subject: Re: Solve a problem of LC_TIME of windows.