Re: [GENERAL] SET SESSION TRANSACTION command

2006-01-01 Thread Tom Lane
"Qingqing Zhou" <[EMAIL PROTECTED]> 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.

Re: [GENERAL] SET SESSION TRANSACTION command

2006-01-01 Thread Tom Lane
Qingqing Zhou <[EMAIL PROTECTED]> writes: > On Sun, 1 Jan 2006, Tom Lane wrote: >> "Qingqing Zhou" <[EMAIL PROTECTED]> writes: >>> test=# SET SESSION TRANSACTION ISOLATION LEVEL SERIALIZABLE; >> >> SESSION is taken as a noise word here. Possibly we should disallow this >> syntax altogether, since

Re: [GENERAL] SET SESSION TRANSACTION command

2006-01-01 Thread Qingqing Zhou
On Sun, 1 Jan 2006, Tom Lane wrote: > "Qingqing Zhou" <[EMAIL PROTECTED]> 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 >

[GENERAL] SET SESSION TRANSACTION command

2006-01-01 Thread Qingqing Zhou
test=# SET SESSION TRANSACTION ISOLATION LEVEL SERIALIZABLE; SET test=# show transaction_isolation; transaction_isolation --- read committed (1 row) Is this a bug by any chance or we do it intentionally? Regards, Qingqing ---(end of broadcast)