DROP ROLE prevented by dependency

Поиск
Список
Период
Сортировка
От Bulgrien, Kevin
Тема DROP ROLE prevented by dependency
Дата
Msg-id 83894A1821034948BA27FE4DAA47427928F7C2990D@apde03.APD.Satcom.Local
обсуждение исходный текст
Ответы Re: DROP ROLE prevented by dependency  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Bosco Rama
Дата:
Сообщение: Re: URGENT: temporary table not recognized?
Следующее
От: Stefan Keller
Дата:
Сообщение: Binary Large Objects (LOB/BLOB) in Hibernate and JDBC: Unresolved issues