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

From Marti Raudsepp
Subject Re: IDLE in transaction introspection
Date
Msg-id CABRT9RALaKEwvoHXRrnqoCcXJN6uFqockkFt5KFkachA8sNBTQ@mail.gmail.com
Whole thread Raw
In response to Re: IDLE in transaction introspection  (Scott Mead <scottm@openscg.com>)
Responses Re: IDLE in transaction introspection
List 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


pgsql-hackers by date:

Previous
From: Noah Misch
Date:
Subject: Re: psql expanded auto
Next
From: Gabriele Bartolini
Date:
Subject: [PATCH] Support for foreign keys with arrays