Postgres Pro
Downloads
Home   >   mailing lists

Re: ALTER DATABASE ... RENAME: permission denied for superuser - Mailing list pgsql-bugs

From Tom Lane
Subject Re: ALTER DATABASE ... RENAME: permission denied for superuser
Date
Msg-id 15018.1110467708@sss.pgh.pa.us
Whole thread Raw
In response to ALTER DATABASE ... RENAME: permission denied for superuser  ("Alexander M. Pravking" <fduch@antar.bryansk.ru>)
List pgsql-bugs
Tree view 
"Alexander M. Pravking" <fduch@antar.bryansk.ru> writes:
> Docs say: Only the database owner or a superuser can rename a database;
> non-superuser owners must also have the CREATEDB privilege.

> Looks like a superuser must have CREATEDB too:

Yeah, the test in RenameDatabase is only looking at createdb and not at
superuserness.  Seems like a bug to me --- or does anyone want to argue
that the code behavior is correct and the docs are wrong?

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Alexander M. Pravking"
Date:
Subject: ALTER DATABASE ... RENAME: permission denied for superuser
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] We are not following the spec for HAVING without GROUP BY