| From: | Stephen Frost <sfrost(at)snowman(dot)net> | 
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> | 
| Cc: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Adam Brightwell <adam(dot)brightwell(at)crunchydatasolutions(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Petr Jelinek <petr(at)2ndquadrant(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> | 
| Subject: | Re: Additional role attributes && superuser review | 
| Date: | 2015-03-02 17:41:22 | 
| Message-ID: | 20150302174122.GP29780@tamriel.snowman.net | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-hackers | 
* Tom Lane (tgl(at)sss(dot)pgh(dot)pa(dot)us) wrote:
> Stephen Frost <sfrost(at)snowman(dot)net> writes:
> > * Alvaro Herrera (alvherre(at)2ndquadrant(dot)com) wrote:
> >> If we were choosing those names nowadays, would we choose CREATEDB at
> >> all in the first place?  I think we'd go for something more verbose,
> >> probably CREATE_DATABASE.  (CREATEROLE is not as old as CREATEDB, but my
> >> bet is that it was modelled after CREATEUSER without considering the
> >> whole readability topic too much.)
> >> 
> >> Anyway it doesn't seem to me that consistency with lack of separators in
> >> those very old names should be our guiding principle here.
> 
> > So you'd advocate EXCLUSIVE_BACKUP and NOEXCLUSIVE_BACKUP?  Or
> > NO_EXCLUSIVE_BACKUP?  Or..?  If this was a green field, I think we might
> > actually use spaces instead, but I'm really not sure we want to go
> > through and redo everything that way at this point..  We'd end up
> > breaking a lot of scripts that currently work today and I'm really not
> > convinced it's better enough to justify that.
> 
> FWIW, I agree with Alvaro, and I'd go with e.g. NO_EXCLUSIVE_BACKUP.
Ok, works for me.  Will update (including tab completion) and send out
for review.
Thanks!
		Stephen
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Heikki Linnakangas | 2015-03-02 17:41:52 | Re: INSERT ... ON CONFLICT {UPDATE | IGNORE} 2.0 | 
| Previous Message | Tom Lane | 2015-03-02 17:39:52 | Re: Additional role attributes && superuser review |