Re: create user problem - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: create user problem
Date
Msg-id 200107092137.f69LbJv22967@candle.pha.pa.us
Whole thread Raw
In response to Re: create user problem  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> Vince Vielhaber <vev@michvhf.com> writes:
> > mydb=# create user foo NOCREATEUSER NOCREATEDB in group bar;
> > ERROR:  parser: parse error at or near "NOCREATEDB"
> 
> > This line:
> >     [ CREATEDB   | NOCREATEDB ] [ CREATEUSER | NOCREATEUSER ]
> > does say I can do both, right?
> 
> It says you can do both *in that order*.
> 
> Feel free to submit a grammar patch to make CREATE USER more flexible
> about the ordering of its optional clauses.  Right now it's pretty
> rigid.

Added to TODO:
* Allow CREATEUSER/CREATEDB ordering in CREATE/ALTER USER

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: AW: New SQL Datatype RECURRINGCHAR
Next
From: Dave Martin
Date:
Subject: timestamp not consistent with documentation or standard