Re: restore to defaults values when commenting of variables in postgresql.conf - Mailing list pgsql-patches

From Tom Lane
Subject Re: restore to defaults values when commenting of variables in postgresql.conf
Date
Msg-id 947.1143668272@sss.pgh.pa.us
Whole thread Raw
In response to restore to defaults values when commenting of variables in postgresql.conf  (BERTHOULE Emmanuel <pgdev@manberth.homeip.net>)
Responses Re: restore to defaults values when commenting of variables  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-patches
BERTHOULE Emmanuel <pgdev@manberth.homeip.net> writes:
> with this patch, you can now restore default value with SIGHUP when
> commenting an variable in postgresql.conf

This seems pretty poorly thought out, in particular making PGC_S_SIGHUP
>= PGC_S_OVERRIDE seems to me likely to break the interaction with other
sources.  Doesn't that cause postgresql.conf to override per-user and
per-database settings?  Why do you need the extra value at all ---
isn't the correct logic just to reset entries with source PGC_S_FILE?

Another problem is that if there's something wrong with the config file,
this will cause all values previously read from the config file to
revert to defaults, which seems less than robust to me.  You really
shouldn't apply the reset until after the file has been parsed.

            regards, tom lane

pgsql-patches by date:

Previous
From: "Steve Woodcock"
Date:
Subject: Re: Improve psql's handling of multi-line queries
Next
From: Philip Yarra
Date:
Subject: Show tablespace for databases with psql's \l+