Re: What default is - SET behavior - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: What default is - SET behavior
Date
Msg-id 200605171349.k4HDnJJ15868@candle.pha.pa.us
Whole thread Raw
In response to What default is - SET behavior  (Zdenek Kotala <zdenek.kotala@sun.com>)
Responses Re: What default is - SET behavior
List pgsql-hackers
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. +


pgsql-hackers by date:

Previous
From: Zdenek Kotala
Date:
Subject: What default is - SET behavior
Next
From: Tom Lane
Date:
Subject: Re: PL/pgSQL 'i = i + 1' Syntax