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

From: Steve Singer <ssinger_pg(at)sympatico(dot)ca>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Andrew Dunstan <andrew(at)dunslane(dot)net>, Greg Sabino Mullane <greg(at)turnstep(dot)com>, hubert depesz lubaczewski <depesz(at)depesz(dot)com>, pgsql-hackers(at)postgresql(dot)org, "Patches (PostgreSQL)" <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Re: [HACKERS] [GENERAL] plperl and regexps with accented characters - incompatible?
Date: 2007-12-02 06:51:09
Message-ID: BAYC1-PASMTP1282C62338636C537F46FDAC730@CEZ.ICE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers 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
>

Attachment Content-Type Size
plperl_test.txt text/plain 528 bytes

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Greg Smith 2007-12-02 08:52:02 Re: power failure....
Previous Message Gurjeet Singh 2007-12-02 03:49:10 Re: Dump/Restore Large Object OID

Browse pgsql-hackers by date

  From Date Subject
Next Message NikhilS 2007-12-02 08:14:20 Re: [HACKERS] BUG #3774: create table like including index doesn't update pg_constraints with primary key
Previous Message Tom Lane 2007-12-02 03:56:31 Re: Help with release note items

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2007-12-02 19:21:31 Re: [PATCHES] Partition: use triggers instead of rules
Previous Message Andrew Dunstan 2007-12-02 00:01:53 Re: Re: [HACKERS] [GENERAL] plperl and regexps with accented characters - incompatible?