Re: TupleTableSlot API problem

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.

In response to

Responses

Browse pgsql-hackers by date

  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