Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Updated TODO item

From: Fernando Nasser <fnasser(at)redhat(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: lockhart(at)fourpalms(dot)org, Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>,Kaare Rasmussen <kar(at)kakidata(dot)dk>, pgsql-patches(at)postgresql(dot)org
Subject: Re: [HACKERS] Updated TODO item
Date: 2002-02-25 14:46:05
Message-ID: 3C7A4E2D.6160062F@redhat.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
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
'userid'.
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
standard
command that uses a syntax to specify the owner I think we should follow
it.


With the additional advantage that the '=' problem goes away and we
avoid
future shift/reduce problems in the parser as 'WITH' is already too
overloaded.


-- 
Fernando Nasser
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 LockhartDate: 2002-02-25 15:05:20
Subject: Re: Open magazine article on open source rdbms
Previous:From: Dave CramerDate: 2002-02-25 14:18:33
Subject: Re: patch queue

pgsql-patches by date

Next:From: Fernando NasserDate: 2002-02-25 14:55:35
Subject: Re: Fix command completion for CREATE TABEL ... AS
Previous:From: Bernhard HerzogDate: 2002-02-25 11:15:26
Subject: Re: Fix for non-blocking connections in libpq

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group