Re: Can't drop table (repost) - Mailing list pgsql-admin

From Tom Lane
Subject Re: Can't drop table (repost)
Date
Msg-id 29906.988221732@sss.pgh.pa.us
Whole thread Raw
In response to Re: Can't drop table (repost)  (Jeremy Buchmann <jeremy@wellsgaming.com>)
List pgsql-admin
Jeremy Buchmann <jeremy@wellsgaming.com> writes:
> So it is one of those temp tables...now if I delete those tables with the
> allow-system-table-mods switch, will that still correct the pg_inherits
> table so that the dependency no longer exists?

Yes, you should be okay once you've dropped the leftover temp tables.

BTW, you should consider updating to a newer release in hopes of getting
rid of the bug that's allowing the temp tables to stick around...

            regards, tom lane

pgsql-admin by date:

Previous
From: Jeremy Buchmann
Date:
Subject: Re: Can't drop table (repost)
Next
From: Jared Sulem
Date:
Subject: Re: Remote login to the database