Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 7243B632EB6 for ; Sun, 2 May 2010 19:55:05 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 65227-03 for ; Sun, 2 May 2010 22:54:52 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from qmta14.westchester.pa.mail.comcast.net (qmta14.westchester.pa.mail.comcast.net [76.96.59.212]) by mail.postgresql.org (Postfix) with ESMTP id D258A632969 for ; Sun, 2 May 2010 19:54:53 -0300 (ADT) Received: from omta22.westchester.pa.mail.comcast.net ([76.96.62.73]) by qmta14.westchester.pa.mail.comcast.net with comcast id Clf91e0041ap0As5EmutFE; Sun, 02 May 2010 22:54:53 +0000 Received: from sz0093.wc.mail.comcast.net ([76.96.58.151]) by omta22.westchester.pa.mail.comcast.net with comcast id Cmut1e0023FmDic3imut3M; Sun, 02 May 2010 22:54:53 +0000 Date: Sun, 2 May 2010 22:54:53 +0000 (UTC) From: Lou Picciano To: pgsql-testers Message-ID: <83647481.4920151272840893052.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net> In-Reply-To: <1497260353.4919431272840766848.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net> Subject: ERROR: unexpected classid 3600 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_254203_252371539.1272840893051" X-Originating-IP: [76.117.184.231] X-Mailer: Zimbra 5.0.19_GA_3172.RHEL5_64 (ZimbraWebClient - SAF3 (Mac)/5.0.19_GA_3177.RHEL5_64) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.009 tagged_above=-10 required=5 tests=BAYES_20=-0.001, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201005/1 X-Sequence-Number: 84 ------=_Part_254203_252371539.1272840893051 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit [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 [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...) ------=_Part_254203_252371539.1272840893051 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable <= div style=3D'font-family: Verdana; font-size: 12pt; color: #000000'>

[T= EST REPORT]

[Release]:&n= bsp;8.5alpha2

[Test Type]:&n= bsp;psql CLI

[Test]: Tr= ying to perform basic change ownership operations using psql; percursor to = dropping the postgres role.

[Pla= tform]: Solaris SPARC 4u (E450)

[Parameters]: based on below (perfectly sensible!) result= , trying to change ownerships...

po= stgres=3D# 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;

ERRO= R:  unexpected classid 3600

[Comments]: Have we somehow corrupted this cluster?  Am seei= ng 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...)

<= /div> ------=_Part_254203_252371539.1272840893051--