[Test Type]: psql CLI
[Test]: Trying to perform basic change ownership operations using psql; percursor to dropping the postgres role.
[Platform]: Solaris SPARC 4u (E450)
[Parameters]: based on below (perfectly sensible!) result, trying to change ownerships...
postgres=# DROP ROLE roleorig;
ERROR: role "roleorig" cannot be dropped because some objects depend on it
DETAIL: owner of database dbone
owner of database dbtwo
owner of database dbthree
1490 objects in database dbfour
# REASSIGN OWNED BY roleorig TO rolenew;
ERROR: unexpected classid 3600
[Comments]: Have we somehow corrupted this cluster? Am seeing other strange behavior related to simple commands:
# CREATE DATABASE dbname;
# GRANT ALL ON dbname TO rolenew;
ERROR: relation "dbname" does not exist
Please note this database is created in lower case; it has not been renamed from upper.
# GRANT ALL ON dbname TO rolenew; - produces the same error.
(I will report this as a different error...)
pgsql-testers by date
|Next:||From: Lou Picciano||Date: 2010-05-02 22:59:35|
|Subject: Trying to GRANT privileges on a newly-created database|
|Previous:||From: Josh Berkus||Date: 2010-04-27 22:29:21|
|Subject: Re: schema.table.column syntax no longer supported?|