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
