| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Magnus Hagander <magnus(at)hagander(dot)net> |
| Cc: | pgsql-committers(at)postgresql(dot)org |
| Subject: | Re: pgsql: Make the pg_stat_activity view call a SRF |
| Date: | 2008-05-07 16:37:10 |
| Message-ID: | 9487.1210178230@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers pgsql-hackers |
mha(at)postgresql(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | User Achernow | 2008-05-07 17:14:16 | libpqtypes - libpqtypes: enhanced html output from groff2html, fixed |
| Previous Message | Bruce Momjian | 2008-05-07 16:36:43 | pgsql: Move Client Authentication right after Server Configuration in |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Aidan Van Dyk | 2008-05-07 16:59:18 | Re: Posting to hackers and patches lists |
| Previous Message | Brendan Jurd | 2008-05-07 16:21:13 | Re: Posting to hackers and patches lists |