
According to \h create user I can stipulate NOCREATEDB and NOCREATEUSER
when I create a user.  But I get this:

mydb=# create user foo NOCREATEUSER NOCREATEDB in group bar;
ERROR:  parser: parse error at or near "NOCREATEDB"
mydb=#

I can create the user by only stipulating one of the NOCREATE items but
not both.   Does that mean something's broke or am I misunderstanding
this:

CREATE USER username
    [ WITH
     [ SYSID uid ]
     [ PASSWORD 'password' ] ]
    [ CREATEDB   | NOCREATEDB ] [ CREATEUSER | NOCREATEUSER ]
    [ IN GROUP     groupname [, ...] ]
    [ VALID UNTIL  'abstime' ]


This line:

    [ CREATEDB   | NOCREATEDB ] [ CREATEUSER | NOCREATEUSER ]

does say I can do both, right?

Vince.
-- 
==========================================================================
Vince Vielhaber -- KA8CSH    email: vev@michvhf.com    http://www.pop4.net
         56K Nationwide Dialup from $16.00/mo at Pop4 Networking
        Online Campground Directory    http://www.camping-usa.com
       Online Giftshop Superstore    http://www.cloudninegifts.com
==========================================================================




Wed, 13 Jun 2001 13:16:18 -0400 (EDT)
Vince Vielhaber <vev@michvhf.com>
create user problem
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.

			regards, tom lane

Wed, 13 Jun 2001 14:53:18 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: create user problem 
On Wed, 13 Jun 2001, Tom Lane wrote:

> 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.

Let me guess, gram.y?

Vince.
-- 
==========================================================================
Vince Vielhaber -- KA8CSH    email: vev@michvhf.com    http://www.pop4.net
         56K Nationwide Dialup from $16.00/mo at Pop4 Networking
        Online Campground Directory    http://www.camping-usa.com
       Online Giftshop Superstore    http://www.cloudninegifts.com
==========================================================================




Wed, 13 Jun 2001 16:20:09 -0400 (EDT)
Vince Vielhaber <vev@michvhf.com>
Re: create user problem 
Vince Vielhaber <vev@michvhf.com> writes:
>> 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.

> Let me guess, gram.y?

Yup.

			regards, tom lane

Wed, 13 Jun 2001 17:09:20 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: create user problem 
> 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, Pennsylvania 19026

Mon, 9 Jul 2001 17:37:19 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: create user problem