Re: IDLE in transaction introspection

On Nov 5, 2011 9:02 AM, "Greg Smith" <greg@2ndquadrant.com> wrote:
>
> 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

+1, it'll be easier to query against.
>
> --
> Greg Smith   2ndQuadrant US    greg@2ndQuadrant.com   Baltimore, MD
> PostgreSQL Training, Services, and 24x7 Support  www.2ndQuadrant.us
>
>
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers