Postgres Pro
Downloads
Home   >   mailing lists

dropping role w/dependent objects - Mailing list pgsql-general

From Ed L.
Subject dropping role w/dependent objects
Date
Msg-id 200704041615.04425.pgsql@bluepolka.net
Whole thread Raw
Responses Re: dropping role w/dependent objects  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
Tree view 
This is pgsql 8.2.3:

% psql -c "drop role mygroup"
ERROR:  role "mygroup" cannot be dropped because some objects
depend on it
DETAIL:  227 objects in this database

How do I identify what these dependent objects are?

I've removed all of the users from this group, turned up server
logging to debug5, and searched docs to no avail.

TIA.
Ed

pgsql-general by date:

Previous
From: Listmail
Date:
Subject: Re: UPDATE on two large datasets is very slow
Next
From: Alvaro Herrera
Date:
Subject: Re: dropping role w/dependent objects