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

pgsql: Make the pg_stat_activity view call a SRF

From: mha(at)postgresql(dot)org (Magnus Hagander)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Make the pg_stat_activity view call a SRF
Date: 2008-05-07 14:41:56
Message-ID: 20080507144156.BFF207559DA@cvs.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committerspgsql-hackers
Log Message:
-----------
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.

Modified Files:
--------------
    pgsql/doc/src/sgml:
        monitoring.sgml (r1.57 -> r1.58)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/monitoring.sgml?r1=1.57&r2=1.58)
    pgsql/src/backend/catalog:
        system_views.sql (r1.49 -> r1.50)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/system_views.sql?r1=1.49&r2=1.50)
    pgsql/src/backend/utils/adt:
        pgstatfuncs.c (r1.49 -> r1.50)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/pgstatfuncs.c?r1=1.49&r2=1.50)
    pgsql/src/include/catalog:
        catversion.h (r1.455 -> r1.456)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/catversion.h?r1=1.455&r2=1.456)
        pg_proc.h (r1.496 -> r1.497)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/pg_proc.h?r1=1.496&r2=1.497)
    pgsql/src/test/regress/expected:
        rules.out (r1.136 -> r1.137)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/rules.out?r1=1.136&r2=1.137)

Responses

pgsql-hackers by date

Next:From: Kevin GrittnerDate: 2008-05-07 14:45:56
Subject: Re: alter + preserving dependencies
Previous:From: Bruce MomjianDate: 2008-05-07 14:28:39
Subject: Re: Posting to hackers and patches lists

pgsql-committers by date

Next:From: User FritshooglandDate: 2008-05-07 15:17:33
Subject: pgstatspack - pgstatspack: Imported Sources
Previous:From: User AchernowDate: 2008-05-07 14:41:55
Subject: libpqtypes - libpqtypes: updated groff2html docs

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