Thread: Re: [HACKERS] Updated TODO item
On Thu, 3 Jan 2002, Bruce Momjian wrote: > Thomas Swan wrote: > > Bruce Momjian wrote: > > > > >TODO: I have added a syntax suggested by someone on IRC: > > > > > >* Make it easier to create a database owned by someone who can't createdb, > > > perhaps CREATE DATABASE dbname WITH USER = "user" > > > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > > > > > Perhaps "CREATE DATABASE dbname WITH USER username" would fit a little > > better. I'd love to see this one get done... ;-) > > OK, I checked at CREATE DATABASE is the only command that has the equals > in WITH PARAM = VAL. Added to TODO: > > * Make equals sign optional in CREATE DATABASE WITH param = 'val' I've revised my previous patch to handle this. Gavin
Attachment
Gavin Sherry wrote: > On Thu, 3 Jan 2002, Bruce Momjian wrote: > > > Thomas Swan wrote: > > > Bruce Momjian wrote: > > > > > > >TODO: I have added a syntax suggested by someone on IRC: > > > > > > > >* Make it easier to create a database owned by someone who can't createdb, > > > > perhaps CREATE DATABASE dbname WITH USER = "user" > > > > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > > > > > > > Perhaps "CREATE DATABASE dbname WITH USER username" would fit a little > > > better. I'd love to see this one get done... ;-) > > > > OK, I checked at CREATE DATABASE is the only command that has the equals > > in WITH PARAM = VAL. Added to TODO: > > > > * Make equals sign optional in CREATE DATABASE WITH param = 'val' > > I've revised my previous patch to handle this. > Thanks. Saved for 7.3. -- 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, Pennsylvania 19026
Your patch has been added to the PostgreSQL unapplied patches list at: http://candle.pha.pa.us/cgi-bin/pgpatches I will try to apply it within the next 48 hours. --------------------------------------------------------------------------- Gavin Sherry wrote: > On Thu, 3 Jan 2002, Bruce Momjian wrote: > > > Thomas Swan wrote: > > > Bruce Momjian wrote: > > > > > > >TODO: I have added a syntax suggested by someone on IRC: > > > > > > > >* Make it easier to create a database owned by someone who can't createdb, > > > > perhaps CREATE DATABASE dbname WITH USER = "user" > > > > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > > > > > > > Perhaps "CREATE DATABASE dbname WITH USER username" would fit a little > > > better. I'd love to see this one get done... ;-) > > > > OK, I checked at CREATE DATABASE is the only command that has the equals > > in WITH PARAM = VAL. Added to TODO: > > > > * Make equals sign optional in CREATE DATABASE WITH param = 'val' > > I've revised my previous patch to handle this. > > Gavin Content-Description: [ Attachment, skipping... ] -- 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, Pennsylvania 19026