Re: What default is - SET behavior

Zdenek Kotala wrote:
> I'm interesting in problem "Allow commenting of variables in 
> postgresql.conf to restore them to defaults".  And I need some clarify 
> of SET command behavior.
> 
> Res_value is defined  in the source code as highest overriding setting 
> during startup (or reconfiguration) and it is used for store "default" 
> value. Hovewer documentation of SET command 
> (http://www.postgresql.org/docs/8.1/interactive/sql-set.html) talk about 
> "DEFAULT can be used to specify resetting the parameter to its default 
> value." And there is question what is the meaning of "default value".  
> Because I understood "default" like value coded in source code - 
> mentioned in the postgresql.conf. 

DEFAULT in this case is session default, which might be the compiled in
default, which can be over-ridden by postgresql.conf, or by a user user
SET command on session start (ALTER USER SET).

--  Bruce Momjian   http://candle.pha.pa.us EnterpriseDB    http://www.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +