Re: Vote totals for SET in aborted transaction

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Hannu Krosing <hannu@tm.ee>
Cc: Scott Marlowe <scott.marlowe@ihs.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2002-04-29T17:04:52Z
Lists: pgsql-hackers
Hannu Krosing <hannu@tm.ee> writes:
> If we go with your syntax I would prefer SET LOCAL to LOCAL SET , so
> that LOCAL feels tied more to variable rather than to SET .

I agree.  I was originally thinking that that way might require LOCAL to
become a reserved word, but we should be able to avoid it.

With Thomas' nearby suggestion of SET SESSION ..., we'd have

	SET [ SESSION | LOCAL ] varname TO value

and it only remains to argue which case is the default ;-)

			regards, tom lane