OK, applied.  I have _not_ backpatched this.

---------------------------------------------------------------------------

Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > Uh, SHOW does show the quotes:
> 
> >     test=> show search_path;
> >       search_path
> >     ----------------
> >      "$user",public
> >     (1 row)
> 
> Hmm ... you're right, it does, so the current default is actually a
> value that you can't get into the variable by a normal SET.
> Interesting.  (We are doing the "smart" stuff during SET not SHOW,
> it appears.)
> 
> regression=# show search_path ;
>  search_path
> --------------
>  $user,public
> (1 row)
> 
> regression=# set search_path = '$user',public;
> SET
> regression=# show search_path ;
>    search_path
> -----------------
>  "$user", public
> (1 row)
> 
> Given that, I agree with changing the default string.  It should look
> the same as a value that you could actually assign ...
> 
>                       regards, tom lane
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
> 

-- 
  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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org

Reply via email to