Re: Per-function search_path => per-function GUC settings

Поиск
Список
Период
Сортировка
От Marko Kreen
Тема Re: Per-function search_path => per-function GUC settings
Дата
Msg-id e51f66da0709030055n3cfbc9a4qe00097fc097f6ddc@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Per-function search_path => per-function GUC settings  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On 9/2/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "Marko Kreen" <markokr@gmail.com> writes:
> > On 9/2/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> >> Seems a little verbose, but maybe we could do "SET var FROM CURRENT"
> >> or "SET var FROM SESSION"?
>
> > I'd prefer FROM SESSION then.  FROM CURRENT seems unclear.
>
> Actually, I think FROM SESSION is unclear, as it opens the question
> whether the value to be applied is the session-wide setting or the
> currently active one.  Inside a transaction that has done SET LOCAL,
> these are different things.

I did not consider that.

> I think we pretty clearly want to have it take the currently active
> setting, and I'd vote for FROM CURRENT as the best way of expressing
> that.

Ok.

-- 
marko


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: Re: [pgsql-www] \dF wrt text search
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: tsearch filenames unlikes special symbols and numbers