Re: Disparity in search_path SHOW and SET - Mailing list pgsql-patches

From Tom Lane
Subject Re: Disparity in search_path SHOW and SET
Date
Msg-id 2749.1135297596@sss.pgh.pa.us
Whole thread Raw
In response to Re: Disparity in search_path SHOW and SET  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Disparity in search_path SHOW and SET
List pgsql-patches
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

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Trouble building 8.1.1 on Tru64 UNIX 5.1
Next
From: Bruce Momjian
Date:
Subject: Re: Disparity in search_path SHOW and SET