SET SESSION SESSION AUTHORIZATION - Mailing list pgsql-hackers

From Dennis Bjorklund
Subject SET SESSION SESSION AUTHORIZATION
Date
Msg-id Pine.LNX.4.44.0410221520120.2015-100000@zigo.dhs.org
Whole thread Raw
Responses Re: SET SESSION SESSION AUTHORIZATION
List pgsql-hackers
Is it just me or is this syntax very ugly?
 SET [ SESSION | LOCAL ] SESSION AUTHORIZATION username SET [ SESSION | LOCAL ] SESSION AUTHORIZATION DEFAULT

so the parser accepts 
 SET SESSION SESSION AUTHORIZATION DEFAULT;

I know the SESSION/LOCAL part should be the same as the other SET 
commands, but still. It hurt my eyes...

The standard command is SET SESSION AUTHORIZATION and affects the session.  
Couldn't we then have this syntax instead
 SET [ SESSION | LOCAL ] AUTHORIZATION username SET [ SESSION | LOCAL ] AUTHORIZATION DEFAULT
                                                   
 
so one can do either
 SET SESSION AUTHORIZATION DEFAULT;

or
 SET LOCAL AUTHORIZATION DEFAULT;

-- 
/Dennis Björklund



pgsql-hackers by date:

Previous
From: Robert Treat
Date:
Subject: Re: Postresql 8.0 Beta 3 - SELECT ... FOR UPDATE
Next
From: Tom Lane
Date:
Subject: Re: timestamp with time zone a la sql99