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