Re: Updated TODO item

Doug McNaught wrote:
> Bruce Momjian <pgman@candle.pha.pa.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@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026