From: | Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: TupleTableSlot API problem |
Date: | 2009-03-30 01:59:39 |
Message-ID: | 87ab73ahys.fsf@news-spur.riddles.org.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
>>>>> "Tom" == Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
Tom> Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> writes:
>> Yup, fails the same way on an --enable-cassert build of 8.3.7.
Tom> Do you have a quick test case? I just finished coding up my
Tom> plan-C fix, and I need some test cases ...
This is the one I've been using:
create or replace function foo(n integer, out a text, out b text)
returns setof record language plpgsql as $f$
begin
return query(select 'foo '||i, 'bar '||i from generate_series(1,n) i);
end;
$f$;
set work_mem=64;
select t.a, t, t.a from foo(100000) t limit 1;
a | t | a
--------------------------------------------------------------+-------------------+-------
\x7F\x7F\x7F\x7F\x7F\x7F\x7F\x7F\x7F\x7F\x7F\x7F\x7F\x7F\x7F | ("foo 1","bar 1") | foo 1
(1 row)
--
Andrew.
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2009-03-30 02:01:03 | Re: Re: [COMMITTERS] pgsql: Temporarily (I hope) disable flattening of IN/EXISTS sublinks |
Previous Message | Tom Lane | 2009-03-30 01:55:36 | Re: TupleTableSlot API problem |