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: [EMAIL PROTECTED]    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
==========================================================================




---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

Reply via email to