Re: Enable pl/python to return records based on multiple OUT params

From: Hannu Krosing <hannu(at)2ndQuadrant(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Enable pl/python to return records based on multiple OUT params
Date: 2008-11-04 15:02:57
Message-ID: 1225810977.7826.1.camel@huvostro
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, 2008-11-04 at 09:57 -0500, Tom Lane wrote:
> Hannu Krosing <hannu(at)2ndQuadrant(dot)com> writes:
> > ... even the code currently in CVS crashes the backend for this
>
> > py=# create or replace function add_any(in i1 anyelement, in i2
> > anyelement, out t text) language plpythonu as $$
> > return i1 + i2
> > $$;
> > CREATE FUNCTION
> > py=# select * from add_any(1,2);
> > server closed the connection unexpectedly
>
> Well, that's just a stupid uninitialized-variable bug :-(

there are probably more complex ones, if a ANYELEMENT taking function is
used more than one time, with different types of args

> regards, tom lane
--
------------------------------------------
Hannu Krosing http://www.2ndQuadrant.com
PostgreSQL Scalability and Availability
Services, Consulting and Training

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2008-11-04 15:07:36 Re: libpq and sslmode=require
Previous Message Tom Lane 2008-11-04 14:57:56 Re: Enable pl/python to return records based on multiple OUT params