Postgres Pro
Downloads
Home   >   mailing lists

Re: Deadlock removal - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Deadlock removal
Date
Msg-id 200409140836.56764.peter_e@gmx.net
Whole thread Raw
In response to Deadlock removal  ("Albrecht Stephen (LWE)" <stephen.albrecht@lwe.liebherr.com>)
List pgsql-general
Tree view 
Albrecht Stephen (LWE) wrote:
> Anybody know how I can simply get rid of this lock?

A lock can only be held by a running transaction.  Therefore, to release
the lock for sure, terminate all other running transactions.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: psql exit status varies for scripts on STDIN
Next
From: Peter Eisentraut
Date:
Subject: Re: psql exit status varies for scripts on STDIN