Postgres Pro
Downloads
Home   >   mailing lists

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

From Ed L.
Subject Re: dropping role w/dependent objects
Date
Msg-id 200704041655.55062.pgsql@bluepolka.net
Whole thread Raw
In response to Re: dropping role w/dependent objects  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: dropping role w/dependent objects  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
Tree view 
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.

Thanks.
Ed

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: newid() in postgres
Next
From: Peter Eisentraut
Date:
Subject: Re: a couple of newbie question - deferrable, varchar vs text, 2 dbs