DROP ROLE prevented by dependency

From: "Bulgrien, Kevin" <Kevin(dot)Bulgrien(at)GDSATCOM(dot)com>
To: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: DROP ROLE prevented by dependency
Date: 2012-01-06 18:00:08
Message-ID: 83894A1821034948BA27FE4DAA47427928F7C2990D@apde03.APD.Satcom.Local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

psql 8.3.16

I've done some searching of mailing list, etc., but have either not searched
the right way, or something. If anyone could throw a bone on this it would
be appreciated. I have no idea what the procedure is for figuring out how
to drop this role:

DROP ROLE myuser;
ERROR: role "myuser" cannot be dropped because some objects depend on it
DETAIL: 1 objects in database postgres

The detail seems kind of skimpy. Any pointers on how to hunt this down?

---
Kevin R. Bulgrien
Design and Development Engineer
http://www.gdsatcom.com/
General Dynamics SATCOM Technologies Tel: 903-295-1480 x24109
3750 W. Loop 281 903-381-4109
Longview, TX 75604-5438 Fax: 903-295-1479

This message and/or attachments may include information subject to GD Corporate Policy 07-105 and is intended to be accessed only by authorized personnel of General Dynamics and approved service providers. Use, storage and transmission are governed by General Dynamics and its policies. Contractual restrictions apply to third parties. Recipients should refer to the policies or contract to determine proper handling. Unauthorized review, use, disclosure or distribution is prohibited. If you are not an intended recipient, please contact the sender and destroy all copies of the original message.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stefan Keller 2012-01-06 18:04:06 Binary Large Objects (LOB/BLOB) in Hibernate and JDBC: Unresolved issues
Previous Message Bosco Rama 2012-01-06 17:53:36 Re: URGENT: temporary table not recognized?