"Maria L. Wilson" <Maria.L.Wilson-1@xxxxxxxx> writes: > yes - how do i get rid of these?? Either COMMIT PREPARED or ROLLBACK PREPARED, depending on whether you think you want those old transactions to take effect or not. (Personally I'd go for ROLLBACK --- if you did not even know those transactions were open, you probably don't want them.) Does anyone remember whether uncommitted prepared transactions block vacuum cleanup in 8.2.x? These things might explain Maria's original problem, too. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
