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