Re: IDLE in transaction introspection

Marti Raudsepp <marti@juffo.org>

From: Marti Raudsepp <marti@juffo.org>

To: Scott Mead <scottm@openscg.com>

Cc: Albe Laurenz <laurenz.albe@wien.gv.at>, "Andrew Dunstan *EXTERN*" <andrew@dunslane.net>, Tom Lane <tgl@sss.pgh.pa.us>, Simon Riggs <simon@2ndquadrant.com>, Robert Haas <robertmhaas@gmail.com>, Magnus Hagander <magnus@hagander.net>, pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2011-11-04T11:39:15Z

Lists: pgsql-hackers

On Wed, Nov 2, 2011 at 20:18, Scott Mead <scottm@openscg.com> wrote:
>    State will display <RUNNING>, <IDLE>, <IDLE> in transaction, etc...

While we're already breaking everything, we could remove the "waiting"
column and use a state with value 'waiting' instead.

Also, returning these as text seems a little lame. Should there be an
enum type for that?

Or we could return single-character mnemonics like some pg_catalog
tables do, and substitute them in the view.

Regards,
Marti