From: Lou Picciano <loupicciano@comcast.net>
To: pgsql-testers <pgsql-testers@postgresql.org>
Subject: ERROR: unexpected classid 3600
Date: Sun, 2 May 2010 22:54:53 +0000 (UTC)
Message-ID: <83647481.4920151272840893052.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net> (raw)
In-Reply-To: <1497260353.4919431272840766848.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net>
[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...)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-testers@postgresql.org
Cc: loupicciano@comcast.net
Subject: Re: ERROR: unexpected classid 3600
In-Reply-To: <83647481.4920151272840893052.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net>
References: <1497260353.4919431272840766848.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net> <83647481.4920151272840893052.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox