Re: [HACKERS] plperl and regexps with accented characters - incompatible?

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To:
Cc: Greg Sabino Mullane <greg(at)turnstep(dot)com>, pgsql-general(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] plperl and regexps with accented characters - incompatible?
Date: 2007-11-12 17:51:33
Message-ID: 473892A5.5090109@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-patches

Andrew Dunstan wrote:
>
>
>
> Greg Sabino Mullane wrote:
>>
>> Yes, we might want to consider making utf8 come pre-loaded for
>> plperl. There is no direct or easy way to do it (we don't have
>> finer-grained control than the 'require' opcode), but we could
>> probably dial back restrictions, 'use' it, and then reset the Safe
>> container to its defaults. Not sure what other problems that may
>> cause, however. CCing to hackers for discussion there.
>>
>>
>>
>
> UTF8 is automatically on for strings passed to plperl if the db
> encoding is UTF8. That includes the source text. Please be more
> precise about what you want.
>
> BTW, the perl docs say this about the utf8 pragma:
>
> Do not use this pragma for anything else than telling Perl that
> your
> script is written in UTF-8.
>
> There should be no need to do that - we will have done it for you. So
> any attempt to use the utf8 pragma in plperl code is probably broken
> anyway.
>
>

Ugh, in testing I see some nastiness here without any explicit require.
It looks like there's an implicit require if the text contains certain
chars. I'll see what I can do to fix the bug, although I'm not sure if
it's possible.

cheers

andrew

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sam Mason 2007-11-12 17:55:23 Re: Linux v.s. Mac OS-X Performance
Previous Message Douglas McNaught 2007-11-12 17:50:21 Re: Linux v.s. Mac OS-X Performance

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2007-11-12 17:56:56 Re: High Availability, Load Balancing, and Replication Feature Matrix
Previous Message Dave Cramer 2007-11-12 17:30:25 Re: [hibernate-team] PostgreSQLDialect

Browse pgsql-patches by date

  From Date Subject
Next Message Andrew Dunstan 2007-11-12 20:29:34 Re: [HACKERS] plperl and regexps with accented characters - incompatible?
Previous Message Andrew Dunstan 2007-11-12 16:56:28 Re: [HACKERS] plperl and regexps with accented characters - incompatible?