dropping role w/dependent objects

From: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: dropping role w/dependent objects
Date: 2007-04-04 22:15:04
Message-ID: 200704041615.04425.pgsql@bluepolka.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-patches

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2007-04-04 22:35:30 Re: dropping role w/dependent objects
Previous Message Listmail 2007-04-04 20:31:17 Re: UPDATE on two large datasets is very slow

Browse pgsql-patches by date

  From Date Subject
Next Message Alvaro Herrera 2007-04-04 22:35:30 Re: dropping role w/dependent objects
Previous Message Nikolay Samokhvalov 2007-04-04 21:22:48 Re: --enable-xml instead of --with-libxml?