Re: How to release a transaction lock on a table - Mailing list pgsql-novice

"info" <info@el-ixir.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