How to release a transaction lock on a table

From: "info" <info(at)el-ixir(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: How to release a transaction lock on a table
Date: 2009-01-08 17:37:50
Message-ID: FCCA0A7FF46B4BB5BFE352C2B7D5DE9C@AmmarLaptop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Dear All,
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.

do u have a way to relese these locks

regards

AJ

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2009-01-08 18:46:08 Re: How to release a transaction lock on a table
Previous Message Nagle, Gail A (US SSA) 2009-01-06 05:00:20 Re: Character Set UTF8 and libpq