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