Re: [BUGS] ALTER DATABASE ... RENAME: permission denied for superuser

2005-03-12 Thread Bruce Momjian
Tom has fixed this bug and backpatched it back to 7.4.X. --- Alexander M. Pravking wrote: > Docs say: Only the database owner or a superuser can rename a database; > non-superuser owners must also have the CREATEDB privilege

Re: [BUGS] ALTER DATABASE ... RENAME: permission denied for superuser

2005-03-10 Thread Tom Lane
"Alexander M. Pravking" <[EMAIL PROTECTED]> 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

[BUGS] ALTER DATABASE ... RENAME: permission denied for superuser

2005-03-10 Thread Alexander M. Pravking
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: [EMAIL PROTECTED] SELECT usesuper, usecreatedb from pg_user where usename = 'fduch'; usesuper | usecreatedb