Re: lock owner - Mailing list pgsql-novice

From Tom Lane
Subject Re: lock owner
Date
Msg-id 11353.980730474@sss.pgh.pa.us
Whole thread Raw
In response to lock owner  (Helge Bahmann <bahmann@math.tu-freiberg.de>)
List pgsql-novice
Helge Bahmann <bahmann@math.tu-freiberg.de> writes:
> If query execution is blocked because a record/table is locked, how can
> I find out which backend is holding the lock?

There isn't any good way right now.  Someone needs to write some code
that dumps out the state of the lock tables in a useful form ...

            regards, tom lane

pgsql-novice by date:

Previous
From: Helge Bahmann
Date:
Subject: lock owner
Next
From: Rasputin
Date:
Subject: Re: When replication?