Re: Reverting SET SESSION AUTHORIZATION command

Tom Lane wrote:
> 
> The syntax that comes to mind offhand is
>         SET SESSION AUTHORIZATION DEFAULT;
> but perhaps someone has a better idea.
> 

Tom,

The SQL standard has already defined what should go there.
That would be CURRENT_USER, so you would have:

SET SESSION AUTHORIZATION CURRENT_USER

Note that CURRENT_USER is _not_ to be affected by a 
It remains the same user that was used for the connection.

The SESSION_USER is the one that changes if you issue a SET 
SESSION AUTHORIZATION (otherwise is the same as the CURRENT_USER).

P.S.: I did not name those things.  Complains to the SQL std committee
:-)

-- 
Fernando Nasser
Red Hat Canada Ltd.                     E-Mail:  fnasser@redhat.com
2323 Yonge Street, Suite #300
Toronto, Ontario   M4P 2C9