Re: Running config vars
От | Peter Eisentraut |
---|---|
Тема | Re: Running config vars |
Дата | |
Msg-id | Pine.LNX.4.30.0105181756410.900-100000@peter.localdomain обсуждение исходный текст |
Ответ на | Re: Running config vars (Bruce Momjian <pgman@candle.pha.pa.us>) |
Список | 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
В списке pgsql-hackers по дате отправления: