Use of LOCAL in SET command - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Use of LOCAL in SET command
Date
Msg-id Pine.LNX.4.44.0206232333570.929-100000@localhost.localdomain
Whole thread Raw
Responses Re: Use of LOCAL in SET command  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Sorry to nag about this so late, but I fear that the new command SET LOCAL
will cause some confusion later on.

SQL uses LOCAL to mean the local node in a distributed system (SET LOCAL
TRANSACTION ...) and the current session as opposed to all sessions (local
temporary table).  The new SET LOCAL command adds the meaning "this
transaction only".  Instead we could simply use SET TRANSACTION, which
would be consistent in behaviour with the SET TRANSACTION ISOLATION LEVEL
command.

Comments?

-- 
Peter Eisentraut   peter_e@gmx.net





pgsql-hackers by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: ODBC Driver 7.02.0001 (Win32) (Unicode mode): CRLF->LF
Next
From: Stephan Szabo
Date:
Subject: Re: pg_dump and ALTER TABLE / ADD FOREIGN KEY