Lists: | pgsql-committerspgsql-hackers |
---|
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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-committers pgsql-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)
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: | Raw Message | Whole Thread | Download mbox | Resend email |
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: | Magnus Hagander <magnus(at)hagander(dot)net> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-committers(at)postgresql(dot)org |
Subject: | Re: pgsql: Make the pg_stat_activity view call a SRF |
Date: | 2008-05-07 17:37:51 |
Message-ID: | 20080507193751.2ecb50bf@mha-laptop.hagander.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-committers pgsql-hackers |
Tom Lane wrote:
> 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?
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
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 21:13:56 |
Message-ID: | 18681.1210194836@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-committers pgsql-hackers |
Magnus Hagander <magnus(at)hagander(dot)net> writes:
> Tom Lane wrote:
>> 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?
Sure, see pg_timezone_abbrevs(), pg_timezone_names().
(This only started to work recently, which is why we have so many
record-returning functions that don't do it that way. It might be
an idea to fix them all sooner or later.)
regards, tom lane
From: | Magnus Hagander <magnus(at)hagander(dot)net> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-committers(at)postgresql(dot)org |
Subject: | Re: pgsql: Make the pg_stat_activity view call a SRF |
Date: | 2008-05-08 09:00:09 |
Message-ID: | 20080508110009.623b13bd@mha-laptop.hagander.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-committers pgsql-hackers |
Tom Lane wrote:
> Magnus Hagander <magnus(at)hagander(dot)net> writes:
> > Tom Lane wrote:
> >> 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?
>
> Sure, see pg_timezone_abbrevs(), pg_timezone_names().
>
> (This only started to work recently, which is why we have so many
> record-returning functions that don't do it that way. It might be
> an idea to fix them all sooner or later.)
Wow, that was easy. Not sure where I got the impression it was hard
from - probably last looked at it before it was made easy, and didn't
re-check :-)
Updated the pg_stat_get_activity() function to use this.
And yes, I agree that it's probably a very good idea to go over our
other SRFs and fix them all. I can take a look at that eventually, but
for now I think we stick it on the TODO?
//Magnus
From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Magnus Hagander <magnus(at)hagander(dot)net> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-committers(at)postgresql(dot)org |
Subject: | Re: pgsql: Make the pg_stat_activity view call a SRF |
Date: | 2008-06-27 02:38:45 |
Message-ID: | 200806270238.m5R2cj728701@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-committers pgsql-hackers |
Magnus Hagander wrote:
> > Sure, see pg_timezone_abbrevs(), pg_timezone_names().
> >
> > (This only started to work recently, which is why we have so many
> > record-returning functions that don't do it that way. It might be
> > an idea to fix them all sooner or later.)
>
> Wow, that was easy. Not sure where I got the impression it was hard
> from - probably last looked at it before it was made easy, and didn't
> re-check :-)
>
> Updated the pg_stat_get_activity() function to use this.
>
> And yes, I agree that it's probably a very good idea to go over our
> other SRFs and fix them all. I can take a look at that eventually, but
> for now I think we stick it on the TODO?
Added to TODO:
* Fix system views like pg_stat_all_tables to use set-returning
functions, rather than views of per-column functions
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
From: | Magnus Hagander <magnus(at)hagander(dot)net> |
---|---|
To: | Bruce Momjian <bruce(at)momjian(dot)us> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-committers(at)postgresql(dot)org |
Subject: | Re: pgsql: Make the pg_stat_activity view call a SRF |
Date: | 2008-06-28 13:34:32 |
Message-ID: | 48663DE8.4040109@hagander.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-committers pgsql-hackers |
Bruce Momjian wrote:
> Magnus Hagander wrote:
>>> Sure, see pg_timezone_abbrevs(), pg_timezone_names().
>>>
>>> (This only started to work recently, which is why we have so many
>>> record-returning functions that don't do it that way. It might be
>>> an idea to fix them all sooner or later.)
>> Wow, that was easy. Not sure where I got the impression it was hard
>> from - probably last looked at it before it was made easy, and didn't
>> re-check :-)
>>
>> Updated the pg_stat_get_activity() function to use this.
>>
>> And yes, I agree that it's probably a very good idea to go over our
>> other SRFs and fix them all. I can take a look at that eventually, but
>> for now I think we stick it on the TODO?
>
> Added to TODO:
>
> * Fix system views like pg_stat_all_tables to use set-returning
> functions, rather than views of per-column functions
Thanks, and while I approve of that TODO, that's not actually the one I
was talking about in the email. The one I was talking about was "change
builtin set-returning functions to use OUT parameters so you can query
them without knowing the result format" or something like that.
So, please keep the one you added, but add this one as well.
//Magnus
From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Magnus Hagander <magnus(at)hagander(dot)net> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-committers(at)postgresql(dot)org |
Subject: | Re: pgsql: Make the pg_stat_activity view call a SRF |
Date: | 2008-08-16 03:49:37 |
Message-ID: | 200808160349.m7G3nbr10695@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-committers pgsql-hackers |
Magnus Hagander wrote:
> Bruce Momjian wrote:
> > Magnus Hagander wrote:
> >>> Sure, see pg_timezone_abbrevs(), pg_timezone_names().
> >>>
> >>> (This only started to work recently, which is why we have so many
> >>> record-returning functions that don't do it that way. It might be
> >>> an idea to fix them all sooner or later.)
> >> Wow, that was easy. Not sure where I got the impression it was hard
> >> from - probably last looked at it before it was made easy, and didn't
> >> re-check :-)
> >>
> >> Updated the pg_stat_get_activity() function to use this.
> >>
> >> And yes, I agree that it's probably a very good idea to go over our
> >> other SRFs and fix them all. I can take a look at that eventually, but
> >> for now I think we stick it on the TODO?
> >
> > Added to TODO:
> >
> > * Fix system views like pg_stat_all_tables to use set-returning
> > functions, rather than views of per-column functions
>
> Thanks, and while I approve of that TODO, that's not actually the one I
> was talking about in the email. The one I was talking about was "change
> builtin set-returning functions to use OUT parameters so you can query
> them without knowing the result format" or something like that.
>
> So, please keep the one you added, but add this one as well.
Uh, I need more details on this. Can you give an example?
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Bruce Momjian <bruce(at)momjian(dot)us> |
Cc: | Magnus Hagander <magnus(at)hagander(dot)net>, pgsql-committers(at)postgresql(dot)org |
Subject: | Re: pgsql: Make the pg_stat_activity view call a SRF |
Date: | 2008-08-16 05:03:43 |
Message-ID: | 6222.1218863023@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-committers pgsql-hackers |
Bruce Momjian <bruce(at)momjian(dot)us> writes:
> Magnus Hagander wrote:
>> Bruce Momjian wrote:
>>> * Fix system views like pg_stat_all_tables to use set-returning
>>> functions, rather than views of per-column functions
>>
>> Thanks, and while I approve of that TODO, that's not actually the one I
>> was talking about in the email. The one I was talking about was "change
>> builtin set-returning functions to use OUT parameters so you can query
>> them without knowing the result format" or something like that.
>>
>> So, please keep the one you added, but add this one as well.
> Uh, I need more details on this. Can you give an example?
Good:
regression=# select * from pg_get_keywords();
word | catcode | catdesc
-------------------+---------+-----------------------
abort | U | Unreserved
absolute | U | Unreserved
access | U | Unreserved
...
Not so good:
regression=# select * from pg_show_all_settings();
ERROR: a column definition list is required for functions returning "record"
There's no longer any very good reason for built-in SRFs to not define
their own output record type.
regards, tom lane
From: | "Jaime Casanova" <jcasanov(at)systemguards(dot)com(dot)ec> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "Bruce Momjian" <bruce(at)momjian(dot)us>, "Magnus Hagander" <magnus(at)hagander(dot)net>, pgsql-committers(at)postgresql(dot)org |
Subject: | Re: pgsql: Make the pg_stat_activity view call a SRF |
Date: | 2008-08-16 23:46:27 |
Message-ID: | 3073cc9b0808161646j5892f708lbcf40275b1afb628@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-committers pgsql-hackers |
On Sat, Aug 16, 2008 at 12:03 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> regression=# select * from pg_show_all_settings();
> ERROR: a column definition list is required for functions returning "record"
>
> There's no longer any very good reason for built-in SRFs to not define
> their own output record type.
>
is there any one doing this? if not i want to give it a try... seems
easy enough, even for me :)
--
regards,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. (593) 87171157
From: | Magnus Hagander <magnus(at)hagander(dot)net> |
---|---|
To: | Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bruce Momjian <bruce(at)momjian(dot)us>, pgsql-committers(at)postgresql(dot)org |
Subject: | Re: pgsql: Make the pg_stat_activity view call a SRF |
Date: | 2008-08-17 18:16:51 |
Message-ID: | 48A86B13.5080800@hagander.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-committers pgsql-hackers |
Jaime Casanova wrote:
> On Sat, Aug 16, 2008 at 12:03 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> regression=# select * from pg_show_all_settings();
>> ERROR: a column definition list is required for functions returning "record"
>>
>> There's no longer any very good reason for built-in SRFs to not define
>> their own output record type.
>>
>
> is there any one doing this? if not i want to give it a try... seems
> easy enough, even for me :)
It's on my list, but I haven't actually started it yet. So - take it away!
//Magnus
From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Magnus Hagander <magnus(at)hagander(dot)net>, PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org> |
Subject: | Re: [COMMITTERS] pgsql: Make the pg_stat_activity view call a SRF |
Date: | 2008-08-18 14:53:51 |
Message-ID: | 200808181453.m7IErpA26226@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-committers pgsql-hackers |
Tom Lane wrote:
> >> Thanks, and while I approve of that TODO, that's not actually the one I
> >> was talking about in the email. The one I was talking about was "change
> >> builtin set-returning functions to use OUT parameters so you can query
> >> them without knowing the result format" or something like that.
> >>
> >> So, please keep the one you added, but add this one as well.
>
> > Uh, I need more details on this. Can you give an example?
>
> Good:
>
> regression=# select * from pg_get_keywords();
> word | catcode | catdesc
> -------------------+---------+-----------------------
> abort | U | Unreserved
> absolute | U | Unreserved
> access | U | Unreserved
> ...
>
> Not so good:
>
> regression=# select * from pg_show_all_settings();
> ERROR: a column definition list is required for functions returning "record"
>
> There's no longer any very good reason for built-in SRFs to not define
> their own output record type.
TODO updated:
* Fix all set-returning system functions so they support a wildcard
target list
SELECT * FROM pg_get_keywords() works but SELECT * FROM
pg_show_all_settings() does not.
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Cc: | Bruce Momjian <bruce(at)momjian(dot)us>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Magnus Hagander <magnus(at)hagander(dot)net> |
Subject: | Re: Re: [COMMITTERS] pgsql: Make the pg_stat_activity view call a SRF |
Date: | 2008-08-20 02:03:04 |
Message-ID: | 200808192203.05185.xzilla@users.sourceforge.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-committers pgsql-hackers |
On Monday 18 August 2008 10:53:51 Bruce Momjian wrote:
> Tom Lane wrote:
> > >> Thanks, and while I approve of that TODO, that's not actually the one
> > >> I was talking about in the email. The one I was talking about was
> > >> "change builtin set-returning functions to use OUT parameters so you
> > >> can query them without knowing the result format" or something like
> > >> that.
> > >>
> > >> So, please keep the one you added, but add this one as well.
> > >
> > > Uh, I need more details on this. Can you give an example?
> >
> > Good:
> >
> > regression=# select * from pg_get_keywords();
> > word | catcode | catdesc
> > -------------------+---------+-----------------------
> > abort | U | Unreserved
> > absolute | U | Unreserved
> > access | U | Unreserved
> > ...
> >
> > Not so good:
> >
> > regression=# select * from pg_show_all_settings();
> > ERROR: a column definition list is required for functions returning
> > "record"
> >
> > There's no longer any very good reason for built-in SRFs to not define
> > their own output record type.
>
> TODO updated:
>
> * Fix all set-returning system functions so they support a wildcard
> target list
>
> SELECT * FROM pg_get_keywords() works but SELECT * FROM
> pg_show_all_settings() does not.
>
If this isn't critical, and no one is working on it yet, I can see about
whittling away at it for 8.4.
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
Cc: | pgsql-hackers(at)postgresql(dot)org, Bruce Momjian <bruce(at)momjian(dot)us>, Magnus Hagander <magnus(at)hagander(dot)net> |
Subject: | Re: Re: [COMMITTERS] pgsql: Make the pg_stat_activity view call a SRF |
Date: | 2008-08-20 02:24:13 |
Message-ID: | 18062.1219199053@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-committers pgsql-hackers |
Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> writes:
> On Monday 18 August 2008 10:53:51 Bruce Momjian wrote:
>> TODO updated:
>> * Fix all set-returning system functions so they support a wildcard
>> target list
> If this isn't critical, and no one is working on it yet, I can see about
> whittling away at it for 8.4.
I think someone did already volunteer.
regards, tom lane
From: | David Fetter <david(at)fetter(dot)org> |
---|---|
To: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
Cc: | pgsql-hackers(at)postgresql(dot)org, Bruce Momjian <bruce(at)momjian(dot)us>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Magnus Hagander <magnus(at)hagander(dot)net> |
Subject: | Re: Re: [COMMITTERS] pgsql: Make the pg_stat_activity view call a SRF |
Date: | 2008-08-20 03:56:45 |
Message-ID: | 20080820035645.GB7447@fetter.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-committers pgsql-hackers |
On Tue, Aug 19, 2008 at 10:03:04PM -0400, Robert Treat wrote:
> On Monday 18 August 2008 10:53:51 Bruce Momjian wrote:
> > Tom Lane wrote:
> > > >> Thanks, and while I approve of that TODO, that's not actually the one
> > > >> I was talking about in the email. The one I was talking about was
> > > >> "change builtin set-returning functions to use OUT parameters so you
> > > >> can query them without knowing the result format" or something like
> > > >> that.
> > > >>
> > > >> So, please keep the one you added, but add this one as well.
> > > >
> > > > Uh, I need more details on this. Can you give an example?
> > >
> > > Good:
> > >
> > > regression=# select * from pg_get_keywords();
> > > word | catcode | catdesc
> > > -------------------+---------+-----------------------
> > > abort | U | Unreserved
> > > absolute | U | Unreserved
> > > access | U | Unreserved
> > > ...
> > >
> > > Not so good:
> > >
> > > regression=# select * from pg_show_all_settings();
> > > ERROR: a column definition list is required for functions returning
> > > "record"
> > >
> > > There's no longer any very good reason for built-in SRFs to not define
> > > their own output record type.
> >
> > TODO updated:
> >
> > * Fix all set-returning system functions so they support a wildcard
> > target list
> >
> > SELECT * FROM pg_get_keywords() works but SELECT * FROM
> > pg_show_all_settings() does not.
> >
>
> If this isn't critical, and no one is working on it yet, I can see about
> whittling away at it for 8.4.
Looks like there are just 5 of these:
SELECT n.nspname as "Schema",
p.proname as "Name",
pg_catalog.pg_get_function_result(p.oid) as "Result data type",
pg_catalog.pg_get_function_arguments(p.oid) as "Argument data types"
FROM pg_catalog.pg_proc p
LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.pronamespace
WHERE p.prorettype <> 'pg_catalog.cstring'::pg_catalog.regtype
AND p.proargtypes[0] IS DISTINCT FROM 'pg_catalog.cstring'::pg_catalog.regtype
AND NOT p.proisagg
AND pg_catalog.pg_get_function_result(p.oid) = 'SETOF record'
AND pg_catalog.pg_get_function_arguments(p.oid) !~ 'OUT'
Schema | Name | Result data type | Argument data types
------------+-----------------------+------------------+---------------------
pg_catalog | pg_cursor | SETOF record |
pg_catalog | pg_lock_status | SETOF record |
pg_catalog | pg_prepared_statement | SETOF record |
pg_catalog | pg_prepared_xact | SETOF record |
pg_catalog | pg_show_all_settings | SETOF record |
(5 rows)
Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
From: | "Jaime Casanova" <jcasanov(at)systemguards(dot)com(dot)ec> |
---|---|
To: | "David Fetter" <david(at)fetter(dot)org> |
Cc: | "Robert Treat" <xzilla(at)users(dot)sourceforge(dot)net>, pgsql-hackers(at)postgresql(dot)org, "Bruce Momjian" <bruce(at)momjian(dot)us>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Magnus Hagander" <magnus(at)hagander(dot)net> |
Subject: | Re: Re: [COMMITTERS] pgsql: Make the pg_stat_activity view call a SRF |
Date: | 2008-08-20 05:18:48 |
Message-ID: | 3073cc9b0808192218i15b940cak35d3fbb85898f937@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-committers pgsql-hackers |
On Tue, Aug 19, 2008 at 10:56 PM, David Fetter <david(at)fetter(dot)org> wrote:
>>
>> If this isn't critical, and no one is working on it yet, I can see about
>> whittling away at it for 8.4.
>
i'm doing it...
> Looks like there are just 5 of these:
>
> pg_catalog | pg_cursor | SETOF record |
> pg_catalog | pg_lock_status | SETOF record |
> pg_catalog | pg_prepared_statement | SETOF record |
> pg_catalog | pg_prepared_xact | SETOF record |
> pg_catalog | pg_show_all_settings | SETOF record |
i have done pg_lock_status and pg_show_all_settings the other three
will do tomorrow
--
regards,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. (593) 87171157