Skip site navigation (1) Skip section navigation (2)

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: 2005-12-23 02:04:40
Message-ID: 200512230204.jBN24ew13370@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
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

In response to

pgsql-hackers by date

Next:From: Christopher Kings-LynneDate: 2005-12-23 02:06:24
Subject: Re: [pgadmin-hackers] Client-side password encryption
Previous:From: Qingqing ZhouDate: 2005-12-23 02:01:09
Subject: Re: what is the smallest working page size for postgresql

pgsql-patches by date

Next:From: Christopher Kings-LynneDate: 2005-12-23 02:08:13
Subject: Re: Disparity in search_path SHOW and SET
Previous:From: Tatsuo IshiiDate: 2005-12-23 01:59:06
Subject: Re: [BUGS] BUG #2120: Crash when doing UTF8<->ISO_8859_8

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group