Re: how can I get "initial_value"(setting_name) ?

Oops,
not my day :-)

many thanks,

Marc Mamin

-----Original Message-----
From: Guillaume Lelarge [mailto:guillaume@lelarge.info] 
Sent: Montag, 12. September 2011 12:16
To: Marc Mamin
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] how can I get "initial_value"(setting_name) ?

On Mon, 2011-09-12 at 11:59 +0200, Marc Mamin wrote:
> differentiated memory settings
> 
> Hello,
> 
> I need to implement differentiate memory settings in order to favor some
> given operations.
> (see function below)
> 
> I miss an admin function to reset the settings to the initial values.
> 
> Do I oversight something ?
> 
> For the case such a function is not yet available, I guess that
> following may prove useful:
> 
> - reset_setting (setting_name [, is_local])

See RESET command
(http://www.postgresql.org/docs/9.0/interactive/sql-reset.html).

> - (read)initial_value(setting_name)
> 

See pg_settings catalog
(http://www.postgresql.org/docs/9.0/interactive/view-pg-settings.html,
columns boot_val and reset_val).


-- 
Guillaume
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com