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

Re: [GENERAL] Missing variable "role" in "pg_settings"?

From: "Florian G(dot) Pflug" <fgp(at)phlo(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org, pgadmin-hackers(at)postgresql(dot)org
Subject: Re: [GENERAL] Missing variable "role" in "pg_settings"?
Date: 2005-12-05 23:10:35
Message-ID: 4394C8EB.5010701@phlo.org (view raw or flat)
Thread:
Lists: pgadmin-hackerspgsql-general
Tom Lane wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
>>Based on this email, should we be showing ROLE from SHOW ALL?
> Only if you think we should be showing session_authorization too.
> That was marked "no_show_all" quite a long time ago, and we have
> not got complaints about it...

Hm, but before 8.1 there was no "alter user set <variable> <value>", was
there? So, a automatic way of retrieving all possible variables wasn't
too important - at least not from a gui-tool perspektive..

Maybe pg_show_all_settings could take an additional parameter indicating
wether to show NO_SHOW_ALL variables or not?

Just my 2 (euro)-cent...

greetings, Florian Pflug

In response to

Responses

pgadmin-hackers by date

Next:From: Andreas PflugDate: 2005-12-05 23:19:31
Subject: Re: [GENERAL] Missing variable "role" in "pg_settings"?
Previous:From: Dave PageDate: 2005-12-05 16:58:44
Subject: Re: New french po updates

pgsql-general by date

Next:From: Andreas PflugDate: 2005-12-05 23:19:31
Subject: Re: [GENERAL] Missing variable "role" in "pg_settings"?
Previous:From: Mark HarrisonDate: 2005-12-05 23:05:55
Subject: mirroring tables to sqlite?

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