Re: TupleTableSlot API problem - Mailing list pgsql-hackers

From Andrew Gierth
Subject Re: TupleTableSlot API problem
Date
Msg-id 87ab73ahys.fsf@news-spur.riddles.org.uk
Whole thread Raw
In response to Re: TupleTableSlot API problem  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: TupleTableSlot API problem  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
List pgsql-hackers
>>>>> "Tom" == Tom Lane <tgl@sss.pgh.pa.us> writes:
Tom> Andrew Gierth <andrew@tao11.riddles.org.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 myTom> 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
returnquery(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.


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: TupleTableSlot API problem
Next
From: Alvaro Herrera
Date:
Subject: Re: Re: [COMMITTERS] pgsql: Temporarily (I hope) disable flattening of IN/EXISTS sublinks