Re: dropping role w/dependent objects

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