Re: Use of LOCAL in SET command

From: Thomas Lockhart <lockhart(at)fourpalms(dot)org>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Use of LOCAL in SET command
Date: 2002-06-24 16:49:21
Message-ID: 3D174D91.C7AB2453@fourpalms.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-06-24 16:53:42 Re: Page OpaqueData
Previous Message Bruce Momjian 2002-06-24 16:40:31 Re: Index Scans become Seq Scans after VACUUM ANALYSE