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
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 |
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 |