paddy carroll <paddy.carroll@gmail.com> writes:
> 3) For 8.3.7 the locks persist a database shutdown and startup cycle - I have had to trash and rebuild the database
inquestion.
> 4) For 8.3.7 I have demonstrated that I can remedy the problem by stopping the database, deleting the contents of
pg_twophaseand pg_subtrans and restarting the database
Egad. Please read about prepared transactions and how to commit them or
roll them back; or else fix your applications to not use them.
regards, tom lane