Re: Use of LOCAL in SET command

Поиск
Список
Период
Сортировка
От Thomas Lockhart
Тема Re: Use of LOCAL in SET command
Дата
Msg-id 3D174D91.C7AB2453@fourpalms.org
обсуждение исходный текст
Ответ на Use of LOCAL in SET command  (Peter Eisentraut <peter_e@gmx.net>)
Список 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 по дате отправления:

Предыдущее
От: "Marc G. Fournier"
Дата:
Сообщение: Re: Our archive searching stinks
Следующее
От: cbbrowne@cbbrowne.com
Дата:
Сообщение: Re: A fairly obvious optimization?