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
