Re: BUG #6511: calling spi_exec_query from non-main package, results in: couldn't fetch $_TD - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #6511: calling spi_exec_query from non-main package, results in: couldn't fetch $_TD
Date
Msg-id 1332189577-sup-8497@alvh.no-ip.org
Whole thread Raw
In response to Re: BUG #6511: calling spi_exec_query from non-main package, results in: couldn't fetch $_TD  (Alex Hunsaker <badalex@gmail.com>)
Responses Re: BUG #6511: calling spi_exec_query from non-main package, results in: couldn't fetch $_TD  (Alex Hunsaker <badalex@gmail.com>)
List pgsql-bugs
Excerpts from Alex Hunsaker's message of mi=C3=A9 mar 07 01:08:25 -0300 201=
2:
> On Sat, Mar 3, 2012 at 12:19,  <marko@kobaz.net> wrote:

> Yeah, there were some optimization done for 9.1 to try and make calls
> a bit faster. The problem is we are fetching "_TD" not "main::_TD",
> which means we try to find and use $_TD from whatever the current
> package is. This should only happen from a nested plperl to plperl
> trigger where the outer call was in a different package, otherwise the
> package is always main.
>=20
> The attached fixes it for me, It would be great if you could confirm that.

Thanks -- applied to 9.1 and master.

--=20
=C3=81lvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #6510: A simple prompt is displayed using wrong charset
Next
From: kebe.1969@gmail.com
Date:
Subject: BUG #6543: pgadmin III - Error defining filter.