DROP ROLE prevented by dependency - Mailing list pgsql-general

From Bulgrien, Kevin
Subject DROP ROLE prevented by dependency
Date
Msg-id 83894A1821034948BA27FE4DAA47427928F7C2990D@apde03.APD.Satcom.Local
Whole thread Raw
Responses Re: DROP ROLE prevented by dependency
List 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
accessedonly by authorized personnel of General Dynamics and approved service providers.  Use, storage and transmission
aregoverned by General Dynamics and its policies. Contractual restrictions apply to third parties.  Recipients should
referto 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.

pgsql-general by date:

Previous
From: Bosco Rama
Date:
Subject: Re: URGENT: temporary table not recognized?
Next
From: Stefan Keller
Date:
Subject: Binary Large Objects (LOB/BLOB) in Hibernate and JDBC: Unresolved issues