Re: Deadlock removal

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: "Albrecht Stephen (LWE)" <stephen(dot)albrecht(at)lwe(dot)liebherr(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Deadlock removal
Date: 2004-09-14 06:36:56
Message-ID: 200409140836.56764.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2004-09-14 06:40:00 Re: psql exit status varies for scripts on STDIN
Previous Message Tom Lane 2004-09-14 05:15:02 Re: psql exit status varies for scripts on STDIN