Re: Disparity in search_path SHOW and SET

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Greg Sabino Mullane" <greg@turnstep.com>
Cc: pgsql-hackers@postgresql.org
Date: 2005-12-20T17:21:20Z
Lists: pgsql-hackers
"Greg Sabino Mullane" <greg@turnstep.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