ERROR: unexpected classid 3600

From: Lou Picciano <loupicciano(at)comcast(dot)net>
To: pgsql-testers <pgsql-testers(at)postgresql(dot)org>
Subject: ERROR: unexpected classid 3600
Date: 2010-05-02 22:54:53
Message-ID: 83647481.4920151272840893052.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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...)

Browse pgsql-testers by date

  From Date Subject
Next Message Lou Picciano 2010-05-02 22:59:35 Trying to GRANT privileges on a newly-created database
Previous Message Josh Berkus 2010-04-27 22:29:21 Re: schema.table.column syntax no longer supported?