Skip site navigation (1) Skip section navigation (2)

Re: pgsql: Make the pg_stat_activity view call a SRF

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 (view raw or flat)
Thread:
Lists: pgsql-committerspgsql-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

In response to

Responses

pgsql-hackers by date

Next:From: Aidan Van DykDate: 2008-05-07 16:59:18
Subject: Re: Posting to hackers and patches lists
Previous:From: Brendan JurdDate: 2008-05-07 16:21:13
Subject: Re: Posting to hackers and patches lists

pgsql-committers by date

Next:From: User AchernowDate: 2008-05-07 17:14:16
Subject: libpqtypes - libpqtypes: enhanced html output from groff2html, fixed
Previous:From: Bruce MomjianDate: 2008-05-07 16:36:43
Subject: pgsql: Move Client Authentication right after Server Configuration in

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group