Postgres Pro
Downloads
Home   >   mailing lists

Re: DROP ROLE prevented by dependency - Mailing list pgsql-general

From Tom Lane
Subject Re: DROP ROLE prevented by dependency
Date
Msg-id 18994.1325874130@sss.pgh.pa.us
Whole thread Raw
In response to DROP ROLE prevented by dependency  ("Bulgrien, Kevin" <Kevin.Bulgrien@GDSATCOM.com>)
Responses Re: DROP ROLE prevented by dependency  ("Bulgrien, Kevin" <Kevin.Bulgrien@GDSATCOM.com>)
List pgsql-general
Tree view 
"Bulgrien, Kevin" <Kevin.Bulgrien@GDSATCOM.com> writes:
> psql 8.3.16
> I've done some searching of mailing list, etc., but have either not searched
> the right way, or something.  If anyone could throw a bone on this it would
> be appreciated.  I have no idea what the procedure is for figuring out how
> to drop this role:

> DROP ROLE myuser;
> ERROR:  role "myuser" cannot be dropped because some objects depend on it
> DETAIL:  1 objects in database postgres

Try the command while connected to the postgres database.  It can't give
you more detail than that from where you are, for lack of visibility
into the other database's system catalogs.

Also, read up on DROP OWNED BY.

            regards, tom lane

pgsql-general by date:

Previous
From: Stefan Keller
Date:
Subject: How PostgreSQL handles Binary Large Objects (LOB/BLOB): types BYTEA, OID/pg_largeobjects and DATALINK
Next
From: Tom Lane
Date:
Subject: Re: How PostgreSQL handles Binary Large Objects (LOB/BLOB): types BYTEA, OID/pg_largeobjects and DATALINK