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

Re: [HACKERS] Updated TODO item

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,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 02:52:04
Message-ID: 200202250252.g1P2q4919000@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Bruce Momjian wrote:
> Tom Lane wrote:
> > Gavin Sherry <swm(at)linuxworld(dot)com(dot)au> writes:
> > > On Fri, 4 Jan 2002, Kaare Rasmussen wrote:
> > >> CREATE DATABASE dbname WITH OWNER = "user"
> > 
> > > A much better idea. There is no conflict in using OWNER here.
> > > Revised patch attached.
> > 
> > I have applied this patch, with a couple of editorial tweaks, and one
> > not-so-minor change: superuser privilege is required to create a
> > database on behalf of another user.  Seems to me that CREATEDB
> > privilege should not be sufficient to allow such an operation.
> > 
> > Still to do: teach createdb script about it, and revise pg_dumpall
> > to use the facility instead of assuming that database owners have
> > CREATEDB privilege.  Working on those now ...
> 
> Seems you are already on that too.  I will wait for you to finish, when
> there will be nothing left for me to do.  :-(

I have applied this minor patch.  I don't want to document the ability
to use equals in this case because some day we may remove it.  The
equals doesn't fit with any of our other WITH clauses.  I cleaned up a
paragraph on OWNER, and mentioned we may want to remove the equals
backward compatibility hack someday.

-- 
  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

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2002-02-25 02:53:41
Subject: Re: 7.2 stuff
Previous:From: Tom LaneDate: 2002-02-25 02:47:36
Subject: Re: [HACKERS] Nice Oracle tuning article

pgsql-patches by date

Next:From: Tom LaneDate: 2002-02-25 02:58:52
Subject: Re: [HACKERS] Updated TODO item
Previous:From: Tom LaneDate: 2002-02-25 02:29:09
Subject: Re: Basic DOMAIN Support

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