Tom Lane wrote:
> Fernando Nasser <fnasser(at)redhat(dot)com> writes:
> > 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?
> Seems like a very weak analogy; there's no other similarities between
> the two command syntaxes, so why argue that this should be the same?
The analogy is not with the command -- it is with with the token
The key word prefix tells what that token is supposed to be, and that
is an <authorization-id>. THe key word AUTHORIZATION works like a sort
of an 'adjective'.
> Also, the semantics aren't the same --- for example, there's no a-priori
> assumption that a database owner owns everything within the database.
I thought you were arguing that neither would a schema (i.e., you wanted
objects in a schema to have different owners).
Anyway, that is not the point here. We have two commands that
create groups of database objects (our "database" is the SQL catalog)
and both specify who will own it. The CREATE DATABASE is implementation
defined and we can do whatever we want with it, but as we have a
command that uses a syntax to specify the owner I think we should follow
With the additional advantage that the '=' problem goes away and we
future shift/reduce problems in the parser as 'WITH' is already too
Red Hat Canada Ltd. E-Mail: fnasser(at)redhat(dot)com
2323 Yonge Street, Suite #300
Toronto, Ontario M4P 2C9
In response to
pgsql-hackers by date
|Next:||From: Thomas Lockhart||Date: 2002-02-25 15:05:20|
|Subject: Re: Open magazine article on open source rdbms|
|Previous:||From: Dave Cramer||Date: 2002-02-25 14:18:33|
|Subject: Re: patch queue|
pgsql-patches by date
|Next:||From: Fernando Nasser||Date: 2002-02-25 14:55:35|
|Subject: Re: Fix command completion for CREATE TABEL ... AS|
|Previous:||From: Bernhard Herzog||Date: 2002-02-25 11:15:26|
|Subject: Re: Fix for non-blocking connections in libpq|