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. + ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
