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

From Scott Mead
Subject Re: IDLE in transaction introspection
Date
Msg-id CAKq0gvLatKsi-N_n9+X_NPwcnPyNSX1a7t548uuOc5apDay7xg@mail.gmail.com
Whole thread Raw
In response to Re: IDLE in transaction introspection  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: IDLE in transaction introspection
List pgsql-hackers

On Thu, Nov 10, 2011 at 2:49 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Bruce Momjian <bruce@momjian.us> writes:
> Well, we could use an optional "details" string for that.  If not, we
> are still using the magic-string approach, which I thought we didn't
> like.

No, we're not using magic strings, we're using an enum --- maybe not an
officially declared enum type, but it's a column with a predetermined
set of possible values.  It would be a magic string if it were still in
the "query" field and thus confusable with user-written queries.

Fell off the map last week, here's v2 that:
 * RUNNING => active
 * all states from CAPS to lower case
  
--
  Scott Mead

                       regards, tom lane

Attachment

pgsql-hackers by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: Disable OpenSSL compression
Next
From: Robert Haas
Date:
Subject: Re: ToDo: pg_backup - using a conditional DROP