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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Florian G(dot) Pflug" <fgp(at)phlo(dot)org>
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-06 05:42:05
Message-ID: 26127.1133847725@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers pgsql-general

"Florian G. Pflug" <fgp(at)phlo(dot)org> writes:
> Tom Lane wrote:
>>> 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..

I don't see the connection offhand ... but ALTER USER SET <variable>
has been around since 7.3, so this doesn't seem to support whatever
argument you intended to make.

regards, tom lane

In response to

Browse pgadmin-hackers by date

  From Date Subject
Next Message Freddy91 (sent by Nabble.com) 2005-12-06 10:57:57 Re: Slony in pgAdmin
Previous Message Andreas Pflug 2005-12-05 23:19:31 Re: [GENERAL] Missing variable "role" in "pg_settings"?

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2005-12-06 05:51:12 Re: Reduce NUMERIC size by 2 bytes, reduce max length to 508
Previous Message Bruce Momjian 2005-12-06 04:59:10 Re: Reduce NUMERIC size by 2 bytes, reduce max length to 508