On Wednesday April 4 2007 4:41 pm, Ed L. wrote: > On Wednesday April 4 2007 4:39 pm, Ed L. wrote: > > On Wednesday April 4 2007 4:35 pm, Alvaro Herrera wrote: > > > Note that you can give the objects owned by that role to > > > someone else with REASSIGN OWNED, and drop the objects > > > with DROP OWNED (note that they act differently regarding > > > grants; see the docs) > > > > Yes, but how do identify what they are so that I know if I > > want to DROP OWNED them? > > The REASSIGN OWNED appears to be insufficient: > > % psql -c "reassign owned by mygroup to mydba" > REASSIGN OWNED > % psql -c "drop group mygroup" > ERROR: role "mygroup" cannot be dropped because some objects > depend on it > DETAIL: 225 objects in this database I did a before and after dump to compare. The objects it is complaining about are GRANTs to that group. Hmm... seems like you shouldn't have to drop every grant for a group you're dropping. Thanks, Ed
