Re: [HACKERS] Updated TODO item

Gavin Sherry <swm@linuxworld.com.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 ...

            regards, tom lane