Re: Add default_val to pg_settings - Mailing list pgsql-hackers

From Greg Smith
Subject Re: Add default_val to pg_settings
Date
Msg-id Pine.GSO.4.64.0809251129210.20724@westnet.com
Whole thread Raw
In response to Re: Add default_val to pg_settings  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
On Thu, 25 Sep 2008, Simon Riggs wrote:

> I would suggest we either alter pg_settings so that we display value
> *only* when source=default (set NULL otherwise) or we do some extra work
> to derive what the setting would be if we ran RESET. The latter would be
> preferred approach.

Since getting the value out when the source!=default is exactly the point 
for the applications I was talking about, I'll rewrite the patch to expose 
the reset_val as well and resubmit shortly.

Thanks for the feedback, your comments helped clarify the use-case for 
reset_val a bit better for me and I'll be sure to document the two columns 
appropriately.  One perspective I don't get to see very often is that of a 
regular user adjusting their settings.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD


pgsql-hackers by date:

Previous
From: Mark Cave-Ayland
Date:
Subject: Missing results from scroll cursor in PostgreSQL 8.3.3?
Next
From: Simon Riggs
Date:
Subject: Re: get_relation_stats_hook()