Re: lock owner

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Helge Bahmann <bahmann(at)math(dot)tu-freiberg(dot)de>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: lock owner
Date: 2001-01-29 01:07:54
Message-ID: 11353.980730474@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Helge Bahmann <bahmann(at)math(dot)tu-freiberg(dot)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

In response to

  • lock owner at 2001-01-28 21:11:38 from Helge Bahmann

Browse pgsql-novice by date

  From Date Subject
Next Message Rasputin 2001-01-29 09:34:14 Re: When replication?
Previous Message Helge Bahmann 2001-01-28 21:11:38 lock owner