Re: IDLE in transaction introspection

Robert Treat <rob@xzilla.net>

From: Robert Treat <rob@xzilla.net>

To: Robert Haas <robertmhaas@gmail.com>

Cc: Scott Mead <scottm@openscg.com>, Tom Lane <tgl@sss.pgh.pa.us>, Marti Raudsepp <marti@juffo.org>, Albe Laurenz <laurenz.albe@wien.gv.at>, "Andrew Dunstan *EXTERN*" <andrew@dunslane.net>, Simon Riggs <simon@2ndquadrant.com>, Magnus Hagander <magnus@hagander.net>, pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2011-11-04T19:47:52Z

Lists: pgsql-hackers

On Fri, Nov 4, 2011 at 3:28 PM, Robert Haas <robertmhaas@gmail.com> wrote:
> On Fri, Nov 4, 2011 at 2:46 PM, Scott Mead <scottm@openscg.com> wrote:
>>    If waiting == true, then state = WAITING
>>    else
>>      state = appropriate state
>
> No, I think the state and waiting columns should be completely independent.
>

If they aren't I don't think we need both columns. +1 for leaving them
independent though.

Robert Treat
play: xzilla.net
work: omniti.com