Use of LOCAL in SET command

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Use of LOCAL in SET command
Дата
Msg-id Pine.LNX.4.44.0206232333570.929-100000@localhost.localdomain
обсуждение исходный текст
Ответы Re: Use of LOCAL in SET command  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Hiroshi Inoue
Дата:
Сообщение: Re: ODBC Driver 7.02.0001 (Win32) (Unicode mode): CRLF->LF
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: pg_dump and ALTER TABLE / ADD FOREIGN KEY