Re: Disparity in search_path SHOW and SET

Christopher Kings-Lynne <chriskl@familyhealth.com.au>

From: Christopher Kings-Lynne <chriskl@familyhealth.com.au>

To: Bruce Momjian <pgman@candle.pha.pa.us>

Cc: Greg Sabino Mullane <greg@turnstep.com>, PostgreSQL-patches <pgsql-patches@postgresql.org>

Date: 2005-12-23T02:08:13Z

Lists: pgsql-hackers

> Agreed.  I have gotten confused on how to set $user in the past.  I have
> developed the following patch that sets the default with the double
> quotes around it, and it works fine.  The patch also contains updated
> documentation.

Just be careful about pg_dump's special handling of search_path in user 
and db variables...

Make sure you haven't broken it.

Chris