pg.ddx.io  pgsql-testers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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...) 

Message-ID: <83647481.4920151272840893052.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net>
Permalink:  ../83647481.4920151272840893052.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net/
Also on:    postgresql.org/message-id/83647481.4920151272840893052.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net

 · 

reply

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