Missing variable "role" in "pg_settings"?

From: "Florian G(dot) Pflug" <fgp(at)phlo(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Missing variable "role" in "pg_settings"?
Date: 2005-11-05 17:39:25
Message-ID: 436CEE4D.3010101@phlo.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers pgsql-general

Hi

The per-session variable "role" is not shown when
doing "select pg_settings". It is, however, possible
to set it using "set role ...", and to query it using
"show role". Is this per design, or is this a bug.

I stumbled over this issue, because pgadmin3 lets
you do "alter user set <variable> <value" using the gui
(You can specify per-user variables in a tab in the
user dialog). But pgadmin only lets one choose variables
that are included in pg_settings, so one cannot archive
the effect of "alter user
<user> set role <role>" (i.e change the initial role of a user)
using the gui. In case omiting role from pg_settings is per design,
how could pgadmin find _all_ variables that can be set per user?

greetings, Florian Pflug

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Florian G. Pflug 2005-11-05 17:49:38 Re: Missing per-user variable?
Previous Message svn 2005-11-05 14:38:31 SVN Commit by dpage: r4666 - in trunk/pgadmin3: . pkg/src src/include

Browse pgsql-general by date

  From Date Subject
Next Message Matthew Terenzio 2005-11-05 18:10:13 joining a query with a select count(*)
Previous Message Andreas Kretschmer 2005-11-05 10:18:40 Re: Postgresql connection on suse 10