Re: Additional role attributes && superuser review - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: Additional role attributes && superuser review
Date
Msg-id 20150302180905.GR29780@tamriel.snowman.net
Whole thread Raw
In response to Re: Additional role attributes && superuser review  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
* Tom Lane (tgl@sss.pgh.pa.us) wrote:
> Alvaro Herrera <alvherre@2ndquadrant.com> writes:
> > That being so, I would consider the idea that the NO bit is a separate
> > word rather than run together with the actual privilege name.  And given
> > that CREATE has all the options default to "NO", there is no need to
> > have these options at all in CREATE, is there?
>
> FWIW, I disagree with that, mainly because I don't think we should cast in
> stone the assumption that NO will always be the default for everything we
> might invent in the future.  Also, the precedent of the existing options
> will lead people to expect that they can explicitly say NO-whatever.

Right, and, in fact, not everything is 'NO' by default today anyway.

Further, people might try to say 'NO CONNECTION LIMIT', and while we
might want to try and support that, there might be options where 'NO'
doesn't actually make sense ('NO VALID UNTIL'?).
Thanks!
    Stephen

pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: remove pg_standby?
Next
From: Jan de Visser
Date:
Subject: Re: Idea: closing the loop for "pg_ctl reload"