Обсуждение: Can't delete role because of unknown object

On 22/04/2014 20:47, Craig Libscomb wrote:
> 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?

I'd hazard a guess that there is another role which is a member of this
one.... connect to the database using psql, and then \du will give you a
list of all roles - in the output from \du, look at the column "Member of".

HTH,

Ray.


--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

Craig Libscomb <craiglibscomb1972@gmail.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.)

            regards, tom lane

On 22/04/2014 21:26, Craig Libscomb wrote:
> On Tue, Apr 22, 2014 at 3:06 PM, Raymond O'Donnell <rod@iol.ie
> <mailto:rod@iol.ie>> wrote:
>
>     On 22/04/2014 20:47, Craig Libscomb wrote:
>     > 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?
>
>     I'd hazard a guess that there is another role which is a member of this
>     one.... connect to the database using psql, and then \du will give you a
>     list of all roles - in the output from \du, look at the column
>     "Member of".
>
>
> All of the roles have {} under "member of", so I assume that means no
> members?

Yes, that's correct. 'Twas worth a look. :-)

Ray.


--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Craig Libscomb
Sent: Tuesday, April 22, 2014 4:27 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Can't delete role because of unknown object

On Tue, Apr 22, 2014 at 3:06 PM, Raymond O'Donnell <rod@iol.ie> wrote:
On 22/04/2014 20:47, Craig Libscomb wrote:
> 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?
I'd hazard a guess that there is another role which is a member of this
one.... connect to the database using psql, and then \du will give you a
list of all roles - in the output from \du, look at the column "Member of".

All of the roles have {} under "member of", so I assume that means no members?
 

HTH,

Ray.


You could try:

SELECT C.relname, C.reltype
FROM pg_class C, pg_authid O
WHERE O.rolname = 'jpate'
AND C.relowner = O.oid;

Regards,
Igor Neyman