From: Joe Conway <joe@conway-family.com>
To: Peter Eisentraut <peter_e@gmx.net>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Jim Buttafuoco <jim@buttafuoco.net>
Cc: pgsql-hackers@postgresql.org
Subject: Re: Running config vars
Date: Fri, 18 May 2001 10:54:59 -0700
Message-ID: <004e01c0dfc3$a9af5230$54d410ac@jecw2k1> (raw)
References: <Pine.LNX.4.30.0105181756410.900-100000@peter.localdomain>
> Bruce Momjian writes:
>
> > I will try to get this feature into 7.2, though as backend code.
>
> I've long been thinking that the SET/RESET/SHOW commands could be
> implemented as stored procedures and/or functions. That way you could
> cleanly return the settings to the client application and compose new
> values out of arbitrary expressions. If ever functions can return
> multiple rows you could also arrange for them to show all current
> settings.
I added a function to the c library that I sent to patches the other day --
called "get_var". It implements what you describe above (that is, one
variable at a time). I'd like to get this into contrib, or do the work
necessary to get it into the backend -- any interest in letting me give that
a try?
Thanks,
Joe
Attachments:
current_db-0.2.tgz (application/x-compressed, 4.2K) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: joe@conway-family.com, peter_e@gmx.net, pgman@candle.pha.pa.us, jim@buttafuoco.net
Subject: Re: Running config vars
In-Reply-To: <004e01c0dfc3$a9af5230$54d410ac@jecw2k1>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox