paddy carroll <paddy.carr...@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 in question.
> 4) For 8.3.7 I have demonstrated that I can remedy the problem by stopping
> the database, deleting the contents of pg_twophase and 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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
