Re: Disparity in search_path SHOW and SET
- From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
- To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
- Cc: Greg Sabino Mullane <greg(at)turnstep(dot)com>, PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>
- Subject: Re: Disparity in search_path SHOW and SET
- Date: Thu, 22 Dec 2005 21:04:40 -0500 (EST)
- Message-id: <200512230204.jBN24ew13370@candle.pha.pa.us> <text/plain>
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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
Home |
Main Index |
Thread Index