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