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
