Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 5C9FE63311F for ; Mon, 23 Aug 2010 14:39:39 -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 15322-02 for ; Mon, 23 Aug 2010 17:39:32 +0000 (UTC) X-Greylist: delayed 00:09:41.81793 by SQLgrey-1.7.6 Received: from maillnx-us111.fmr.com (maillnx-us111.fmr.com [192.223.198.26]) by mail.postgresql.org (Postfix) with ESMTP id 4D155632E1A for ; Mon, 23 Aug 2010 14:39:32 -0300 (ADT) X-filenames: None Received: from msgmrosm01win.dmn1.fmr.com ([172.26.7.127]) by maillnx-us111.fmr.com with SMTP; 23 Aug 2010 13:29:48 -0400 Received: from msgrtpiv03vwin.FMR.COM (10.93.69.194) by MSGMROSM01WIN.dmn1.fmr.com (Sigaba Gateway v4.1) with ESMTP id 336231774; Mon, 23 Aug 2010 13:29:48 -0400 X-TM-IMSS-Message-ID: <0252206f0000fde7@msgrtpiv03vwin.fmr.com> Received: from MSGMROIM01WIN.DMN1.FMR.COM ([172.26.2.194]) by msgrtpiv03vwin.fmr.com ([10.93.69.194]) with ESMTP (TREND IMSS SMTP Service 7.0) id 0252206f0000fde7 ; Mon, 23 Aug 2010 13:29:56 -0400 Received: from msgbosclm2win.DMN1.FMR.COM ([10.46.17.17]) by MSGMROIM01WIN.DMN1.FMR.COM with Microsoft SMTPSVC(5.0.2195.7381); Mon, 23 Aug 2010 13:29:47 -0400 X-MimeOLE: Produced By Microsoft Exchange V6.0.6619.12 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Subject: Unable to drop role Date: Mon, 23 Aug 2010 13:29:47 -0400 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Unable to drop role Thread-Index: ActC6MgGPxO7oQuvRiWVhAbLVwuiHA== From: "McGehee, Robert" To: X-OriginalArrivalTime: 23 Aug 2010 17:29:47.0214 (UTC) FILETIME=[C8659EE0:01CB42E8] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-4.2 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_MED=-2.3 X-Spam-Level: X-Archive-Number: 201008/156 X-Sequence-Number: 35405 PostgreSQL developers, I am unable to drop a role with presumably no object dependencies or connection access on my PostgreSQL 8.4.2 installation (64-bit OSX). Any help would be greatly appreciated as I've spent way too much time trying to execute a simple command. template1=3D# DROP ROLE a485099; ERROR: role "a485099" cannot be dropped because some objects depend on it DETAIL: access to database template1 template1=3D# \du a485099; List of roles Role name | Attributes | Member of -----------+------------+----------- a485099 | | {} template1=3D# REVOKE CONNECT ON DATABASE template1 FROM a485099; REVOKE template1=3D# REASSIGN OWNED BY a485099 TO postgres; REASSIGN OWNED template1=3D# DROP OWNED BY a485099; REASSIGN OWNED template1=3D# DROP ROLE a485099; ERROR: role "a485099" cannot be dropped because some objects depend on it DETAIL: access to database template1 What am I missing?=20 Thanks, Robert