Re: SET SESSION TRANSACTION command - Mailing list pgsql-general

From Tom Lane
Subject Re: SET SESSION TRANSACTION command
Date
Msg-id 28488.1136146948@sss.pgh.pa.us
Whole thread Raw
In response to SET SESSION TRANSACTION command  ("Qingqing Zhou" <zhouqq@cs.toronto.edu>)
Responses Re: SET SESSION TRANSACTION command  (Qingqing Zhou <zhouqq@cs.toronto.edu>)
List pgsql-general
"Qingqing Zhou" <zhouqq@cs.toronto.edu> writes:
> test=# SET SESSION TRANSACTION ISOLATION LEVEL SERIALIZABLE;

SESSION is taken as a noise word here.  Possibly we should disallow this
syntax altogether, since it isn't SQL-spec ... but I'm not sure it's
worth contorting the grammar enough to do that.

The converse case is

    SET LOCAL SESSION CHARACTERISTICS AS ...

which is also allowed but probably is going to do something confusing.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Last line is not read from postgres.conf
Next
From: Qingqing Zhou
Date:
Subject: Re: SET SESSION TRANSACTION command