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

From info
Subject Re: How to release a transaction lock on a table
Date
Msg-id C453A8E18EBB4A61B274138A7E896680@AmmarLaptop
Whole thread Raw
In response to Re: How to release a transaction lock on a table  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: How to release a transaction lock on a table
List pgsql-novice
Dear Sir,

thanks . I have tried to commit the transaction using PREPCOMMIT but the
statement is not supported by my postgre.
I am using postgre version 8.1.10. I can not batch postgre.  is their
another ways to solve this problem

best regards

Ammar
----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "info" <info@el-ixir.com>
Cc: <pgsql-novice@postgresql.org>
Sent: Thursday, January 08, 2009 8:46 PM
Subject: Re: [NOVICE] How to release a transaction lock on a table


> "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
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice


pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Postgesql lib
Next
From: Tom Lane
Date:
Subject: Re: How to release a transaction lock on a table