| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | "Ed L(dot)" <pgsql(at)bluepolka(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: dropping role w/dependent objects |
| Date: | 2007-04-04 23:02:46 |
| Message-ID: | 20070404230246.GJ19251@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-patches |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ed L. | 2007-04-04 23:08:28 | Re: dropping role w/dependent objects |
| Previous Message | Alvaro Herrera | 2007-04-04 22:57:22 | Re: dropping role w/dependent objects |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ed L. | 2007-04-04 23:08:28 | Re: dropping role w/dependent objects |
| Previous Message | Alvaro Herrera | 2007-04-04 22:57:22 | Re: dropping role w/dependent objects |