Search Postgresql Archives

DROP ROLE prevented by dependency

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux