Re: [HACKERS] Updated TODO item

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: 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:00:11
Message-ID: 200202250200.g1P20B712625@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

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. :-(

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

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-02-25 02:17:22 Re: elog() proposal
Previous Message Tatsuo Ishii 2002-02-25 01:54:25 Re: Bug #602: Chinese characters query bug.

Browse pgsql-patches by date

  From Date Subject
Next Message Rod Taylor 2002-02-25 02:24:49 Re: Basic DOMAIN Support
Previous Message Tom Lane 2002-02-25 01:24:49 Re: [HACKERS] Updated TODO item