"info" <info(at)el-ixir(dot)com> writes:
> I have some open locks on some table in my postgre data base. I have closed every application, I have restarted the DB, and I have also restart the server machine itself. but the lock is still their.
select * from pg_prepared_xacts;
commit or rollback as appropriate
regards, tom lane