Re: pgsql: Make the pg_stat_activity view call a SRF

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
Thread:
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

In response to

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2008-08-17 19:40:11 pgsql: Add some defenses against constant-FALSE outer join conditions.
Previous Message Tom Lane 2008-08-17 02:19:20 pgsql: Remove prohibition against SubLinks in the WHERE clause of an

Browse pgsql-hackers by date

  From Date Subject
Next Message Oleg Bartunov 2008-08-17 18:34:47 any psql static binary for iphone ?
Previous Message Asko Oja 2008-08-17 18:07:51 Re: [PgFoundry] Unsigned Data Types