SET TRANSACTION and SQL Standard

Поиск
Список
Период
Сортировка
Искать
От
Simon Riggs
Тема
SET TRANSACTION and SQL Standard
Дата
Msg-id
1230748030.4032.78.camel@ebony.2ndQuadrant
Список
Дерево обсуждения
SET TRANSACTION and SQL Standard Simon Riggs <simon@2ndQuadrant.com>
Re: SET TRANSACTION and SQL Standard Peter Eisentraut <peter_e@gmx.net>
Re: SET TRANSACTION and SQL Standard Simon Riggs <simon@2ndQuadrant.com>
Re: SET TRANSACTION and SQL Standard Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: SET TRANSACTION and SQL Standard Simon Riggs <simon@2ndQuadrant.com>
Re: SET TRANSACTION and SQL Standard Tom Lane <tgl@sss.pgh.pa.us>
Re: SET TRANSACTION and SQL Standard Simon Riggs <simon@2ndQuadrant.com>
Re: SET TRANSACTION and SQL Standard Bruce Momjian <bruce@momjian.us>
Re: SET TRANSACTION and SQL Standard Tom Lane <tgl@sss.pgh.pa.us>
Re: SET TRANSACTION and SQL Standard Peter Eisentraut <peter_e@gmx.net>
Re: SET TRANSACTION and SQL Standard Tom Lane <tgl@sss.pgh.pa.us>
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.comPostgreSQL Training, Services and Support


В списке pgsql-hackers по дате отправления
От: Simon Riggs
Дата:
От: David Fetter
Дата:
FAQ