Skip site navigation (1) Skip section navigation (2)

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 (view raw, whole thread or download thread mbox)
Lists: pgsql-generalpgsql-hackerspgsql-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.


> 			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: plperl_test.txt
Description: text/plain (528 bytes)

In response to

pgsql-hackers by date

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

pgsql-patches by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group