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

From Thomas Lockhart
Subject Re: Use of LOCAL in SET command
Date
Msg-id 3D174D91.C7AB2453@fourpalms.org
Whole thread Raw
In response to Use of LOCAL in SET command  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
> 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.

Yes. If there is a possibility of confusion (now or later) over SQL99
syntax, we should do it The Right Way per spec.
                - Thomas




pgsql-hackers by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: Our archive searching stinks
Next
From: cbbrowne@cbbrowne.com
Date:
Subject: Re: A fairly obvious optimization?