Re: IDLE in transaction introspection

Greg Smith <greg@2ndquadrant.com>

From: Greg Smith <greg@2ndQuadrant.com>
To: pgsql-hackers@postgresql.org
Date: 2011-11-05T02:29:58Z
Lists: pgsql-hackers
On 11/04/2011 05:01 PM, Tom Lane wrote:
> Scott Mead<scottm@openscg.com>  writes:
>    
>>     I leave the waiting flag in place for posterity.  With this in mind, is
>> the consensus:
>>     RUNNING
>>      or
>>     ACTIVE
>>      
> Personally, I'd go for lower case.
>    

I was thinking it would be nice if this state looked like the WAL sender 
state values in pg_stat_replication, which are all lower case.  For 
comparison those states are:

startup
backup
catchup
streaming

-- 
Greg Smith   2ndQuadrant US    greg@2ndQuadrant.com   Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support  www.2ndQuadrant.us