Re: pgsql/ oc/src/sgml/ref/set_session_auth.sgml r ... - Mailing list pgsql-committers

From Tom Lane
Subject Re: pgsql/ oc/src/sgml/ref/set_session_auth.sgml r ...
Date
Msg-id 322.1021058591@sss.pgh.pa.us
Whole thread Raw
In response to Re: pgsql/ oc/src/sgml/ref/set_session_auth.sgml r ...  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-committers
Peter Eisentraut <peter_e@gmx.net> writes:
> I noticed you added SHOW SESSION AUTHORIZATION here as showing the
> SESSION_USER.  I don't think this makes sense, because SET SESSION
> AUTHORIZATION is not the same as setting the session user only.

Well, I added the SHOW mainly so that I could test the thing more
easily, so I'm not wedded to it --- but why not?  Why shouldn't
SHOW SESSION AUTHORIZATION show what you last SET?  Not sure about
the distinction you are trying to draw.

> Also, in response to your comment, no, I don't think RESET all should
> reset the session user.

Fine, I didn't think so either ... though this might keep us from
folding it into the GUC variables, which was my next project in
that area...

            regards, tom lane

pgsql-committers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: pgsql/ oc/src/sgml/ref/set_session_auth.sgml r ...
Next
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql/src/backend/tcop postgres.c