On Jul 21, 2011, at 5:06 PM, [email protected] wrote:
> I point out that Pg itself supports Perl for stored procedures in PL/Perl.
> What if I have a perl program which wants to store a perl procedure to the
> database? I have not done such a thing myself I use stored procedures very
> seldom but I could see interesting possibilities
This issue was fixed in 9.0 in PL/Perl. This is the relevant release note:
• Verify that PL/Perl return values are valid in the server encoding
(Andrew Dunstan)
What this means is that it's up to you to return data from Perl in the server
encoding, IIRC. If the server encoding is UTF-8, then IIRC things should just
work.
Would be nice to see this spelled out in the docs somewhere, though. Think I'll
bug Andrew about that.
Best,
David
