Re: [SOLVED] Can't delete role because of unknown object

On Tue, Apr 22, 2014 at 3:30 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> Craig Libscomb <craiglibscomb1972(at)gmail(dot)com> writes:
> > The following command:
> > DROP USER IF EXISTS jpate;
>
> > generates the following output:
> > ERROR: role "jpate" cannot be dropped because some objects depend on it
> > DETAIL: 1 object in database products
>
> > It would be most helpful to know what object in the products database
> > depends on the jpate role, but I am unable to find anything that even
> > begins to offer a clue. What command will show me this mysterious object,
> > please?
>
> You need to connect to that database and try the DROP USER from there.
> It's not possible to produce very much info about the problematic
> object when not connected to its database. (I suppose we could tell
> you the object kind, ie table/function/etc, but not more than that.)

*sigh*, yep, I was connected to the wrong database. After connecting
the error told me the dependency was privileges on the public schema.
REVOKEing those then allowed me to DROP the user.

Thanks!

>
>
> regards, tom lane