Re: Per-function search_path => per-function GUC settings - Mailing list pgsql-hackers

From Marko Kreen
Subject Re: Per-function search_path => per-function GUC settings
Date
Msg-id e51f66da0709030055n3cfbc9a4qe00097fc097f6ddc@mail.gmail.com
Whole thread Raw
In response to Re: Per-function search_path => per-function GUC settings  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: [pgsql-www] \dF wrt text search
Next
From: Magnus Hagander
Date:
Subject: Re: tsearch filenames unlikes special symbols and numbers