Re: show() function - Mailing list pgsql-patches

From Joe Conway
Subject Re: show() function
Date
Msg-id 3D17593D.8060608@joeconway.com
Whole thread Raw
In response to Re: show() function  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: show() function
List pgsql-patches
Peter Eisentraut wrote:
 > Joe Conway writes:
 >>Attached is a patch which (I believe) addresses Peter's concerns with
 >>respect to the previous showguc patch. In this patch, contrib/showguc is
 >>gone, the term GUC is not exposed to user space, and a builtin
 >>show('gucvarname') function returning a single scalar value has been
 >>added, e.g.:
 >
 > I think this patch still includes a number of leftovers from previous
 > attempts, such as a get option by number function.

I was hoping it would be acceptable to leave this function in (as well
as the one to get the number of config variables), once it was renamed
to remove the reference to GUC.

Without it, it is impossible for a user function to return a list of
config variables without prior knowledge of the config variable names. I
would still like to have this ability. The only workaround without these
functions is to parse "SHOW ALL" output which is an awfully ugly
alternative.

Joe





pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [ODBC] PostgreSQL 7.2.1 and Sun's C compiler under
Next
From: Joe Conway
Date:
Subject: Re: show() function