pg.ddx.io pgsql-hackers@postgresql.org mailing list archive
help / color / mirror / Atom feedRunning config vars
7+ messages / 5 participants
[nested] [flat]
* Running config vars
@ 2001-05-16 16:53 Jim Buttafuoco <jim@buttafuoco.net>
2001-05-18 14:39 ` Re: Running config vars Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 1 reply; 7+ messages in thread
From: Jim Buttafuoco @ 2001-05-16 16:53 UTC (permalink / raw)
To: pgsql-hackers
Hi all (I hope this is the correct list),
Under Oracle there is v$parameter which list ALL config varables. Under
psql there is the SHOW command, but this only lists 1 variable. I have
written a shell script (attached) that shows ALL know variables. My
questions is can this script get included under contrib directory and is
there a way to make it into a view. I believe this kind of info will
help in trouble shooting problems.
thanks
Jim
Attachments:
pg_conf (application/octet-stream, 1.6K) download
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Running config vars
2001-05-16 16:53 Running config vars Jim Buttafuoco <jim@buttafuoco.net>
@ 2001-05-18 14:39 ` Bruce Momjian <pgman@candle.pha.pa.us>
2001-05-18 15:59 ` Re: Running config vars Peter Eisentraut <peter_e@gmx.net>
0 siblings, 1 reply; 7+ messages in thread
From: Bruce Momjian @ 2001-05-18 14:39 UTC (permalink / raw)
To: Jim Buttafuoco <jim@buttafuoco.net>; +Cc: pgsql-hackers
I will try to get this feature into 7.2, though as backend code.
[ Charset ISO-8859-1 unsupported, converting... ]
> Hi all (I hope this is the correct list),
>
> Under Oracle there is v$parameter which list ALL config varables. Under
> psql there is the SHOW command, but this only lists 1 variable. I have
> written a shell script (attached) that shows ALL know variables. My
> questions is can this script get included under contrib directory and is
> there a way to make it into a view. I believe this kind of info will
> help in trouble shooting problems.
>
> thanks
> Jim
>
>
[ application/octet-stream is not supported, skipping... ]
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Running config vars
2001-05-16 16:53 Running config vars Jim Buttafuoco <jim@buttafuoco.net>
2001-05-18 14:39 ` Re: Running config vars Bruce Momjian <pgman@candle.pha.pa.us>
@ 2001-05-18 15:59 ` Peter Eisentraut <peter_e@gmx.net>
2001-05-18 17:54 ` Re: Running config vars Joe Conway <joe@conway-family.com>
0 siblings, 1 reply; 7+ messages in thread
From: Peter Eisentraut @ 2001-05-18 15:59 UTC (permalink / raw)
To: Bruce Momjian <pgman@candle.pha.pa.us>; +Cc: Jim Buttafuoco <jim@buttafuoco.net>; pgsql-hackers
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.
>
>
> [ Charset ISO-8859-1 unsupported, converting... ]
> > Hi all (I hope this is the correct list),
> >
> > Under Oracle there is v$parameter which list ALL config varables. Under
> > psql there is the SHOW command, but this only lists 1 variable. I have
> > written a shell script (attached) that shows ALL know variables. My
> > questions is can this script get included under contrib directory and is
> > there a way to make it into a view. I believe this kind of info will
> > help in trouble shooting problems.
--
Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Running config vars
2001-05-16 16:53 Running config vars Jim Buttafuoco <jim@buttafuoco.net>
2001-05-18 14:39 ` Re: Running config vars Bruce Momjian <pgman@candle.pha.pa.us>
2001-05-18 15:59 ` Re: Running config vars Peter Eisentraut <peter_e@gmx.net>
@ 2001-05-18 17:54 ` Joe Conway <joe@conway-family.com>
0 siblings, 0 replies; 7+ messages in thread
From: Joe Conway @ 2001-05-18 17:54 UTC (permalink / raw)
To: Peter Eisentraut <peter_e@gmx.net>; Bruce Momjian <pgman@candle.pha.pa.us>; +Cc: Jim Buttafuoco <jim@buttafuoco.net>; pgsql-hackers
> 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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Fw: Running config vars
@ 2001-05-16 17:02 Jim Buttafuoco <jim@tylerdrive.org>
2001-05-16 17:17 ` Re: Fw: Running config vars Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 1 reply; 7+ messages in thread
From: Jim Buttafuoco @ 2001-05-16 17:02 UTC (permalink / raw)
To: pgsql-hackers
Hi all (I hope this is the correct list),
Under Oracle there is v$parameter which list ALL config varables. Under
psql there is the SHOW command, but this only lists 1 variable. I have
written a shell script (attached) that shows ALL know variables. My
questions is can this script get included under contrib directory and is
there a way to make it into a view. I believe this kind of info will
help in trouble shooting problems.
thanks
Jim
Attachments:
pg_conf (application/octet-stream, 1.6K) download
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Fw: Running config vars
2001-05-16 17:02 Fw: Running config vars Jim Buttafuoco <jim@tylerdrive.org>
@ 2001-05-16 17:17 ` Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 0 replies; 7+ messages in thread
From: Bruce Momjian @ 2001-05-16 17:17 UTC (permalink / raw)
To: Jim Buttafuoco <jim@tylerdrive.org>; +Cc: pgsql-hackers
I think the way to do this is for SHOW ALL to show all setttings.
[ Charset ISO-8859-1 unsupported, converting... ]
>
> Hi all (I hope this is the correct list),
>
> Under Oracle there is v$parameter which list ALL config varables. Under
> psql there is the SHOW command, but this only lists 1 variable. I have
> written a shell script (attached) that shows ALL know variables. My
> questions is can this script get included under contrib directory and is
> there a way to make it into a view. I believe this kind of info will
> help in trouble shooting problems.
>
> thanks
> Jim
>
>
>
>
>
>
[ application/octet-stream is not supported, skipping... ]
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Fw: Running config vars
@ 2001-05-16 17:20 Jim Buttafuoco <jim@tylerdrive.org>
0 siblings, 0 replies; 7+ messages in thread
From: Jim Buttafuoco @ 2001-05-16 17:20 UTC (permalink / raw)
To: pgsql-hackers
I was looking for some way via standard SQL (I use perl DBI) to list
these variables. I don't believe the SHOW command is available via DBI
Jim
>
> I think the way to do this is for SHOW ALL to show all setttings.
>
> [ Charset ISO-8859-1 unsupported, converting... ]
> >
> > Hi all (I hope this is the correct list),
> >
> > Under Oracle there is v$parameter which list ALL config varables.
Under
> > psql there is the SHOW command, but this only lists 1 variable. I
have
> > written a shell script (attached) that shows ALL know variables. My
> > questions is can this script get included under contrib directory
and is
> > there a way to make it into a view. I believe this kind of info
will
> > help in trouble shooting problems.
> >
> > thanks
> > Jim
> >
> >
> >
> >
> >
> >
>
> [ application/octet-stream is not supported, skipping... ]
>
> >
> > ---------------------------(end of
broadcast)---------------------------
> > TIP 3: if posting/reading through Usenet, please send an appropriate
> > subscribe-nomail command to majordomo@postgresql.org so that your
> > message can get through to the mailing list cleanly
>
> --
> Bruce Momjian | http://candle.pha.pa.us
> pgman@candle.pha.pa.us | (610) 853-3000
> + If your life is a hard drive, | 830 Blythe Avenue
> + Christ can be your backup. | Drexel Hill, Pennsylvania
19026
>
>
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2001-05-18 17:54 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-05-16 16:53 Running config vars Jim Buttafuoco <jim@buttafuoco.net>
2001-05-18 14:39 ` Bruce Momjian <pgman@candle.pha.pa.us>
2001-05-18 15:59 ` Peter Eisentraut <peter_e@gmx.net>
2001-05-18 17:54 ` Joe Conway <joe@conway-family.com>
2001-05-16 17:02 Fw: Running config vars Jim Buttafuoco <jim@tylerdrive.org>
2001-05-16 17:17 ` Bruce Momjian <pgman@candle.pha.pa.us>
2001-05-16 17:20 Re: Fw: Running config vars Jim Buttafuoco <jim@tylerdrive.org>
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