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