Skip site navigation (1) Skip section navigation (2)

Re: Bug in server status view

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Magnus Hagander <magnus(at)hagander(dot)net>
Cc: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: Bug in server status view
Date: 2011-05-04 19:04:17
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgadmin-hackers
On 05/04/2011 07:57 PM, Magnus Hagander wrote:
> The server status view does not properly display the "blocked by"
> field, unless it's blocked by a table level lock. In particular, if
> you create a row-lock, it shows empty.
> Attached patch changes two things:
> 1) Detects lock conflicts on transaction id's, which is where row
> locks normally show up
> 2) Change it so that if we know the query is blocked, but we can't
> figure out who it's blocked by, it shows -1. Today, it just shows
> NULL, which is exactly the same as it shows if it is not blocked at
> all - making it quite useless...
> Comments?

Seems great to me.


In response to

pgadmin-hackers by date

Next:From: Guillaume LelargeDate: 2011-05-04 19:06:45
Subject: Re: pgAdmin 1.14 Visual Tour
Previous:From: Dave PageDate: 2011-05-04 18:05:19
Subject: Re: pgAdmin 1.14 Visual Tour

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group