Re: How to release a transaction lock on a table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "info" <info(at)el-ixir(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: How to release a transaction lock on a table
Date: 2009-01-08 18:46:08
Message-ID: 18857.1231440368@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message kulmacet101 2009-01-08 19:34:49 invalid byte sequence for encoding "UTF8":
Previous Message info 2009-01-08 17:37:50 How to release a transaction lock on a table