Re: bug #1702: nested composite types in plpgsql

From: Roman Neuhauser <neuhauser(at)sigpipe(dot)cz>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: bug #1702: nested composite types in plpgsql
Date: 2005-09-15 10:41:15
Message-ID: 20050915104115.GB38644@isis.sigpipe.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

# tgl(at)sss(dot)pgh(dot)pa(dot)us / 2005-09-13 12:17:06 -0400:
> Roman Neuhauser <neuhauser(at)sigpipe(dot)cz> writes:
> > Looking at src/pl/plpgsql/src/pl_exec.c for the first time, is it a problem
> > of make_tuple_from_row() not accounting for nested composite types?
>
> Looks that way. I've committed a fix to HEAD. I'm not sure how hard
> it'd be to fix 8.0.

Thanks for the fast fix, it's really appreciated.

I tried to hammer[1] your patch[2] onto the REL8_0_STABLE branch
(attached), but am getting

ERROR: out of memory
DETAIL: Failed on request of size 1073741823.
CONTEXT: PL/pgSQL function "breakme" while storing call arguments
into local variables

I'm sorry to be a nuisance, but is this interesting enough for
someone in the know that they'd backport the patch into 8.0?

[1] see attachment
[2] http://developer.postgresql.org/cvsweb.cgi/pgsql/src/pl/plpgsql/src/pl_exec.c.diff?r1=1.151;r2=1.152

--
How many Vietnam vets does it take to screw in a light bulb?
You don't know, man. You don't KNOW.
Cause you weren't THERE. http://bash.org/?255991

Attachment Content-Type Size
src:pl:plpgsql:src:pl_exec.c.REL8_0_STABLE,0.patch text/plain 1.6 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim Buttafuoco 2005-09-15 11:46:26 Re: Per-table freeze limit proposal
Previous Message Hans-Juergen Schoenig 2005-09-15 07:56:38 Re: random system table corruption ...