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: 4DC1A331.9060303@lelarge.info (view raw or flat)
Thread:
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.


-- 
Guillaume
 http://www.postgresql.fr
 http://dalibo.com

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-2014 The PostgreSQL Global Development Group