Re: IDLE in transaction introspection - Mailing list pgsql-hackers

From Tom Lane
Subject Re: IDLE in transaction introspection
Date
Msg-id 5843.1320414122@sss.pgh.pa.us
Whole thread Raw
In response to Re: IDLE in transaction introspection  (Marti Raudsepp <marti@juffo.org>)
Responses Re: IDLE in transaction introspection
Re: IDLE in transaction introspection
List pgsql-hackers
Marti Raudsepp <marti@juffo.org> writes:
> While we're already breaking everything, we could remove the "waiting"
> column and use a state with value 'waiting' instead.

-1 ... I think it's useful to see the underlying state as well as the
waiting flag.  Also, this would represent breakage of part of the API
that doesn't need to be broken.

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

Perhaps, but we don't really use enum types in any other system views,
so inventing one here would be out of character.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: Show statistics target in \d+
Next
From: Robert Haas
Date:
Subject: Re: Show sequences owned by