Re: Re: [HACKERS] [GENERAL] plperl and regexps with accented characters - incompatible? - Mailing list pgsql-patches

From Steve Singer
Subject Re: Re: [HACKERS] [GENERAL] plperl and regexps with accented characters - incompatible?
Date
Msg-id BAYC1-PASMTP1282C62338636C537F46FDAC730@CEZ.ICE
Whole thread Raw
In response to Re: Re: [HACKERS] [GENERAL] plperl and regexps with accented characters - incompatible?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
On Sat, 1 Dec 2007, Tom Lane wrote:

> I wrote:
>> I got around to trying it with a dusty 5.6.1 I have laying about on my
>> HPPA machine, and the news is not good: CREATE LANGUAGE plperl dumps
>> core deep inside libperl.  With or without this patch.
>
>> As best I can tell at the moment, I have not tested 5.6.1 with anything
>> later than our 7.2 branch, so I don't know exactly where the breakage
>> slipped in.  It may be of long standing.
>
> Actually, libperl seems to dump core in the same place in every PG
> version, back to and including 7.2, so what seems more likely is that
> this copy of perl is just plain broken.  Since we didn't have any form
> of regression test for plperl back then, it's entirely possible that
> I never tested any further than compiling plperl with that setup.
>
> So we still need someone to try it with a good copy of 5.6 ...


I tested cvs head which includes the patch on Solaris 9/SPARC with perl
5.6.1 and it seems to work fine.


Test output attached.

Steve


>
>             regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>       choose an index scan if your joining column's datatypes do not
>       match
>

pgsql-patches by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Re: [HACKERS] [GENERAL] plperl and regexps with accented characters - incompatible?
Next
From: Tom Lane
Date:
Subject: Re: [DOCS] Partition: use triggers instead of rules