Use of LOCAL in SET command

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Use of LOCAL in SET command
Date: 2002-06-23 21:52:08
Message-ID: Pine.LNX.4.44.0206232333570.929-100000@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmx(dot)net

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Stephan Szabo 2002-06-23 23:55:44 Re: pg_dump and ALTER TABLE / ADD FOREIGN KEY
Previous Message Peter Eisentraut 2002-06-23 21:51:10 Re: SQL99, CREATE CAST, and initdb