Re: Releasing locks - Mailing list pgsql-novice

From Tom Lane
Subject Re: Releasing locks
Date
Msg-id 27093.975192811@sss.pgh.pa.us
Whole thread Raw
In response to Releasing locks  (GH <grasshacker@over-yonder.net>)
Responses Re: Releasing locks  (GH <grasshacker@over-yonder.net>)
List pgsql-novice
GH <grasshacker@over-yonder.net> writes:
> Is there some way to release the "bad" lock?

Kill the client holding it.

In a persistent-connection environment, you'd have to ensure that any
connection that client had open was closed, not just recycled to the
free pool.  Hmm, another thing I bet PHP doesn't do ...

            regards, tom lane

pgsql-novice by date:

Previous
From: GH
Date:
Subject: Releasing locks
Next
From: GH
Date:
Subject: Re: Releasing locks