Doug McNaught wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> 
> > > Shouldn't that be
> > > 
> > > CREATE DATABASE dbname WITH OWNER = "user"
> > > 
> > > ?
> > 
> > Yes!  OWNER is much better.  TODO updated and I will save this message
> > for changes in 7.3:
> 
> Will this make OWNER into a new keyword, and break schemas that have
> "owner" as a table or column name?  USER is at least already a
> keyword...

We already use OWNER in ALTER TABLE so it is not really a new keyword:

        | ALTER TABLE relation_name OWNER TO UserId

Also, its usage is limited to CREATE TABLE so I believe a column named
owner is still possible, as it is now.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

In response to

• Re: Updated TODO item at 2002-01-04 18:58:09 from Doug McNaught

pgsql-hackers by date

Next:	From: Dwayne Miller	Date: 2002-01-04 19:32:09
	Subject: Re: Syntax changes in 7.2
Previous:	From: Doug McNaught	Date: 2002-01-04 18:58:09
	Subject: Re: Updated TODO item

pgsql-patches by date

Next:	From: Jon Marks	Date: 2002-01-04 21:39:15
	Subject: libpq seed PRNG for SSL support
Previous:	From: Doug McNaught	Date: 2002-01-04 18:58:09
	Subject: Re: Updated TODO item