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

From: Alex Hunsaker <badalex(at)gmail(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: marko(at)kobaz(dot)net, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6511: calling spi_exec_query from non-main package, results in: couldn't fetch $_TD
Date: 2012-03-16 17:48:24
Message-ID: CAFaPBrTXmwj+iAMe2g7RsGg5qBm5KGvNJVy7Nezo0mZyjwYqhA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Thu, Mar 15, 2012 at 16:13, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> On Tue, Mar 06, 2012 at 09:08:25PM -0700, Alex Hunsaker wrote:
>> [ Calling a plperl trigger function from a plperl function ]
>>
>> 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.
>>
>> The attached fixes it for me, It would be great if you could confirm that.
>>
>> Thanks for the report!
>
> So, should this be applied?

Yes, but I would like to get conformation that it fixes the issue.
Either way Ill probably just end up submitting it to the next commit
fest. (I know most commiters are still busy with the current one).

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2012-03-16 17:54:02 Re: [BUGS] BUG #6532: pg_upgrade fails on Python stored procedures
Previous Message Tom Lane 2012-03-16 17:17:46 Re: Regression from 8.4 to 9.1.2/9.1.3: Optimizing filters on constants in unions