Re: Disparity in search_path SHOW and SET

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Disparity in search_path SHOW and SET
Date: 2005-12-20 17:21:20
Message-ID: 765.1135099280@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

"Greg Sabino Mullane" <greg(at)turnstep(dot)com> writes:
> This works fine:

> SELECT set_config('search_path', '$schema,' || current_setting('search_path'), true);

> ...but does not last outside of a transaction.

Well, sure, because you told it to. Why isn't the last parameter
"false"?

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Martin Pitt 2005-12-20 17:27:55 Re: horology regression test failure
Previous Message Greg Sabino Mullane 2005-12-20 17:15:46 Disparity in search_path SHOW and SET

Browse pgsql-patches by date

  From Date Subject
Next Message Greg Sabino Mullane 2005-12-20 17:30:07 Re: Disparity in search_path SHOW and SET
Previous Message Greg Sabino Mullane 2005-12-20 17:15:46 Disparity in search_path SHOW and SET