> Vince Vielhaber <[EMAIL PROTECTED]> 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
Vince Vielhaber <[EMAIL PROTECTED]> 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
--
On Wed, 13 Jun 2001, Tom Lane wrote:
> Vince Vielhaber <[EMAIL PROTECTED]> 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 s
Vince Vielhaber <[EMAIL PROTECTED]> 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 *
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 it