Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id B932E6509C7
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Tue,  8 Jul 2008 13:58:52 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 62048-03-8 for
	<pgsql-admin-postgresql.org@postgresql.org>;
	Tue,  8 Jul 2008 13:58:45 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from web35906.mail.mud.yahoo.com (web35906.mail.mud.yahoo.com
	[66.163.179.190])
	by postgresql.org (Postfix) with SMTP id A2B066509EE
	for <pgsql-admin@postgresql.org>; Tue,  8 Jul 2008 13:44:43 -0300 (ADT)
Received: (qmail 50843 invoked by uid 60001); 8 Jul 2008 16:44:33 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Received:X-Mailer:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type:Message-ID;
	b=Jot/bIzPvYTHjnmWr902Dq7WdE17tI8ObUqFHOtQSCButjN9uc987R5bA8KGEUH3nGDJZw1xm4V3dqlgg2bJnTQ8eKPr0wACZ6I+QBmRGBp77Lztg4xZf+1CVfBQBPpodbIYVHqzdmpsU8MsjEarauChG0RR+v2y09hdIIgxeFw=;
Received: from [199.200.10.52] by web35906.mail.mud.yahoo.com via HTTP;
	Tue, 08 Jul 2008 09:44:32 PDT
X-Mailer: YahooMailWebService/0.7.199
Date: Tue, 8 Jul 2008 09:44:32 -0700 (PDT)
From: Rex Mabry <rexmabry@yahoo.com>
Reply-To: rexmabry@yahoo.com
Subject: dropping a user in 8.2.6
To: pgsql-admin@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-2100811511-1215535472=:50750"
Message-ID: <956278.50750.qm@web35906.mail.mud.yahoo.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200807/89
X-Sequence-Number: 29699

--0-2100811511-1215535472=:50750
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

I am using version 8.2.6
=A0
I created a role and granted all on table "instrument"=A0in=A0the database.=
=A0 But, when I tried to drop the role, I get the following error:
=A0
mydb=3D# drop role system_dba;
ERROR:=A0 role "user1" cannot be dropped because some objects depend on it
DETAIL:=A0 access to table mydb_admin.instrument

Is there a way to drop a role with some sort of "cascade" option?=0A=0A=0A =
     
--0-2100811511-1215535472=:50750
Content-Type: text/html; charset=us-ascii

<table cellspacing='0' cellpadding='0' border='0' ><tr><td valign='top' style='font: inherit;'><P>I am using version 8.2.6</P>
<P>&nbsp;</P>
<P>I created a role and granted all on table "instrument"&nbsp;in&nbsp;the database.&nbsp; But, when I tried to drop the role, I get the following error:</P>
<P>&nbsp;</P>
<P>mydb=# drop role system_dba;<BR>ERROR:&nbsp; role "user1" cannot be dropped because some objects depend on it<BR>DETAIL:&nbsp; access to table mydb_admin.instrument<BR><BR>Is there a way to drop a role with some sort of "cascade" option?</P></td></tr></table><br>

      
--0-2100811511-1215535472=:50750--