ERROR: unexpected classid 3600 - Mailing list pgsql-testers

From Lou Picciano
Subject ERROR: unexpected classid 3600
Date
Msg-id 83647481.4920151272840893052.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net
Whole thread Raw
List pgsql-testers

[TEST REPORT]

[Release]: 8.5alpha2

[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

<etc>

[Failure]:

[Results]: 

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

Previous
From: Josh Berkus
Date:
Subject: Re: schema.table.column syntax no longer supported?
Next
From: Lou Picciano
Date:
Subject: Trying to GRANT privileges on a newly-created database