Hays Steve - sthays wrote:
> There is a schema we created and has been in use for several months that
> now seems to have some objects that cannot be dropped. When I attempt to
> drop a suspect table in this schema, the process just runs, as though it
> is being blocked by an active DML process, but this is even after a
> server restart.
Maybe you have prepared transactions. Look in the pg_prepared_xacts
view, and issue ROLLBACK PREPARED or COMMIT PREPARED if so.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support