Re: take 2: show all / reset all

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Marko Kreen <marko(at)l-t(dot)ee>, pgsql-patches(at)postgresql(dot)org
Subject: Re: take 2: show all / reset all
Date: 2001-06-11 22:19:30
Message-ID: 200106112219.f5BMJUp19679@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches


Looks like this is fixed in the pending patch that uses GUC calls to set
variables from the command line.

> Tom Lane writes:
>
> > This looks fairly bogus, given the comment on ResetAllOptions:
> >
> > /*
> > * Reset all options to their specified default values. Should only be
> > * called at program startup.
> > */
> >
> > Or is that OK now with the "makeDefault" addition to SetConfigOption?
>
> Evidently not quite:
>
> peter=# show port;
> NOTICE: port is 6543
> SHOW VARIABLE
> peter=# reset all;
> RESET VARIABLE
> peter=# show port;
> NOTICE: port is 5432
> SHOW VARIABLE
>
> This is because I started the postmaster with -p 6543, but that assigns to
> the variable directly and does not save it as default.
>
> --
> Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2001-06-11 22:52:52 Re: Australian timezone configure option
Previous Message Bruce Momjian 2001-06-11 22:13:03 Re: YA readline 4.2 patch