Skip site navigation (1) Skip section navigation (2)

Add default_val to pg_settings

From: Greg Smith <gsmith(at)gregsmith(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Add default_val to pg_settings
Date: 2008-09-16 04:10:32
Message-ID: Pine.GSO.4.64.0809152349440.19910@westnet.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Attached is an updated and separate version of my patch exposing the 
internal GUC boot_val as default_val, which failed to attach itself to the 
already committed changes to the pg_settings view.

Brief reminder of what it does:

postgres=# select name,setting,default_val from pg_settings where name='shared_buffers';
       name      | setting | default_val
----------------+---------+-------------
  shared_buffers | 4096    | 1024

General justification for this change with a longer example is at 
http://archives.postgresql.org/pgsql-hackers/2008-09/msg00233.php

Based on feedback the first time around, I updated the documentation for 
this column to read "Default value assumed at server startup if the 
parameter is not otherwise set".

Would only take a quick search/replace of the patch to change 
"default_val" to something else if there are still any objections there. 
"boot_val" is another candidate name, I feel that would make the purpose 
of the column less obvious to users of pg_settings even if it is more 
correct. I'm really more concerned about the feature than exactly what 
it's named though. I didn't bother to expose the reset_val since I can't 
think of any obvious use cases for wanting to know it.

--
* Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD

Attachment: guc-with-defaults-2.patch
Description: text/plain (13.1 KB)

Responses

pgsql-hackers by date

Next:From: Sushant SinhaDate: 2008-09-16 04:47:32
Subject: text search patch status update?
Previous:From: Tom LaneDate: 2008-09-16 02:40:33
Subject: Re: plpgsql is not translate-aware

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group