Re: IDLE in transaction introspection

On Nov 5, 2011 9:02 AM, "Greg Smith" <greg(at)2ndquadrant(dot)com> wrote:
>
> On 11/04/2011 05:01 PM, Tom Lane wrote:
>>
>> Scott Mead<scottm(at)openscg(dot)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(at)2ndQuadrant(dot)com Baltimore, MD
> PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us
>
>
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers