Tom Lane wrote: > [EMAIL PROTECTED] (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?
That does sound like a very good idea... I did notice that as being a problem, but didn't know how to fix it without thinking more :-) How do I do that in pg_proc.h? Is there some other function that does this that I can peek at for inspiration? //Magnus -- Sent via pgsql-committers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
