SET SESSION SESSION AUTHORIZATION

From: Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: SET SESSION SESSION AUTHORIZATION
Date: 2004-10-22 13:30:55
Message-ID: Pine.LNX.4.44.0410221520120.2015-100000@zigo.dhs.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jan Wieck 2004-10-22 13:36:10 Re: [Slony1-general] Re: Slony-I 1.0.4 Released
Previous Message Jan Wieck 2004-10-22 13:26:49 Re: Slony-I 1.0.4 Released