"Maria L. Wilson" <Maria(dot)L(dot)Wilson-1(at)nasa(dot)gov> 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