Re: pgsql: Make the pg_stat_activity view call a SRF - Mailing list pgsql-committers

From Tom Lane
Subject Re: pgsql: Make the pg_stat_activity view call a SRF
Date
Msg-id 9487.1210178230@sss.pgh.pa.us
Whole thread Raw
In response to pgsql: Make the pg_stat_activity view call a SRF  (mha@postgresql.org (Magnus Hagander))
Responses Re: pgsql: Make the pg_stat_activity view call a SRF
List pgsql-committers
mha@postgresql.org (Magnus Hagander) writes:
> Make the pg_stat_activity view call a SRF (pg_stat_get_activity())
> instead of calling a bunch of individual functions.

> This function can also be called directly, taking a PID as an argument, to
> return only the data for a single PID.

Hmm, if you really intend the function to be used directly, then having
to provide the output column list for it is a pretty big usability hit.
Why not declare it with OUT parameters, instead?

            regards, tom lane

pgsql-committers by date:

Previous
From: momjian@postgresql.org (Bruce Momjian)
Date:
Subject: pgsql: Move Client Authentication right after Server Configuration in
Next
From: achernow@pgfoundry.org (User Achernow)
Date:
Subject: libpqtypes - libpqtypes: enhanced html output from groff2html, fixed