Re: [HACKERS] Updated TODO item

Thomas Lockhart wrote:
>
> > > > * Make it easier to create a database owned by someone who can't createdb,
> > > >   perhaps CREATE DATABASE dbname WITH USER = "user"
> > > CREATE DATABASE dbname WITH OWNER = "user"
> > A much better idea. There is no conflict in using OWNER here.
>
> Does this have the multiple "WITH xxx" clauses which were discussed
> earlier? That is a nonstarter for syntax. There are other places in the
> grammar having "with clauses" and multiple arguments or subclauses, and
> having the shift/reduce issues resolved...
>

The syntax of the CREATE SCHEMA SQL standard command is

CREATE SCHEMA AUTHORIZATION userid

Shouldn't we be using

CREATE DATABASE AUTHORIZATION userid

to be consistent?

--
Fernando Nasser
Red Hat Canada Ltd.                     E-Mail:  fnasser@redhat.com
2323 Yonge Street, Suite #300
Toronto, Ontario   M4P 2C9