Horton
Menu

Re: Disparity in search_path SHOW and SET

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

View thread
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Cc: Greg Sabino Mullane <greg@turnstep.com>, PostgreSQL-patches <pgsql-patches@postgresql.org>
Date: 2005-12-23T02:04:40Z
Lists: pgsql-hackers 
Christopher Kings-Lynne wrote:
> > 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.

Uh, could you provide a test I can do?   The code is already in CVS.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073