Re: dropping role w/dependent objects - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: dropping role w/dependent objects
Date
Msg-id 20070404230246.GJ19251@alvh.no-ip.org
Whole thread Raw
In response to Re: dropping role w/dependent objects  ("Ed L." <pgsql@bluepolka.net>)
Responses Re: dropping role w/dependent objects  ("Ed L." <pgsql@bluepolka.net>)
List pgsql-general
Ed L. wrote:
> On Wednesday April 4 2007 4:48 pm, Alvaro Herrera wrote:
> > > Yes, but how do identify what they are so that I know if I
> > > want to DROP OWNED them?
> >
> > There's no way AFAICT, short of peeking the catalogs (or
> > information_schema).  Try pg_shdepend.
>
> I guess if the bug were fixed, it'd be a non-issue.

Sure, please submit a patch.  It should not be too difficult.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: dropping role w/dependent objects
Next
From: "Ed L."
Date:
Subject: Re: dropping role w/dependent objects