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

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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: 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-01 17:36:31
Message-ID: 5272.1196530591@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackerspgsql-patches
Andrew Dunstan <andrew(at)dunslane(dot)net> writes:
> The version I tested against is 5.8.8 -  the latest stable release. The 
> 5.8 series started in 2003 from what I can see - if anyone has a 
> sufficiently old system that they can test on 5.6.2 that will be useful. 

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.

Core was generated by `postgres'.
Program terminated with signal 11, Segmentation fault.

warning: Can't find file postmaster referenced in dld_list.
Reading symbols from /usr/lib/libxnet.1...done.
Reading symbols from /usr/lib/libc.1...done.
Reading symbols from /usr/lib/libdld.1...done.
Reading symbols from /home/postgres/testversion/lib/plperl.sl...done.
Reading symbols from /opt/perl5.6.1/lib/5.6.1/PA-RISC2.0/CORE/libperl.sl...
done.
Reading symbols from /usr/lib/libnsl_s.1...done.
Reading symbols from /usr/lib/libM.1...done.
Reading symbols from /usr/lib/libsec.1...done.
#0  0xc00a02fc in ?? () from /usr/lib/libc.1
(gdb) bt
#0  0xc00a02fc in ?? () from /usr/lib/libc.1
#1  0xc6fc3bb4 in ?? ()
   from /opt/perl5.6.1/lib/5.6.1/PA-RISC2.0/CORE/libperl.sl
#2  0xc6f5a99c in ?? ()
   from /opt/perl5.6.1/lib/5.6.1/PA-RISC2.0/CORE/libperl.sl
#3  0xc6f570a4 in ?? ()
   from /opt/perl5.6.1/lib/5.6.1/PA-RISC2.0/CORE/libperl.sl
#4  0xc6f56c88 in ?? ()
   from /opt/perl5.6.1/lib/5.6.1/PA-RISC2.0/CORE/libperl.sl
#5  0xc0d2b660 in plperl_init_interp () at plperl.c:429
#6  0xc0d2b2bc in _PG_init () at plperl.c:213
#7  0x3ce9f0 in internal_load_library (
    libname=0xf8 <Address 0xf8 out of bounds>) at dfmgr.c:296
#8  0x3ce4a4 in load_external_function (filename=0x4016086c "  \037(", 
    funcname=0x40062924 "", signalNotFound=1 '\001', filehandle=0x7b03bb8c)
    at dfmgr.c:110
#9  0x1af7fc in fmgr_c_validator (fcinfo=0x4016086c) at pg_proc.c:509
#10 0x3d1a98 in OidFunctionCall1 (functionId=1075185772, arg1=49153)
    at fmgr.c:1527
#11 0x1af530 in ProcedureCreate (
    procedureName=0x401075f8 "plperl_call_handler", procNamespace=11, 
    replace=0 '\000', returnsSet=0 '\000', returnType=2280, 
    languageObjectId=13, languageValidator=2247, 

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Greg Sabino MullaneDate: 2007-12-01 18:25:10
Subject: Re: Re: [HACKERS] [GENERAL] plperl and regexps with accented characters - incompatible?
Previous:From: Tom LaneDate: 2007-12-01 16:23:58
Subject: Re: .NET or Mono functions in PG

pgsql-patches by date

Next:From: Greg Sabino MullaneDate: 2007-12-01 18:25:10
Subject: Re: Re: [HACKERS] [GENERAL] plperl and regexps with accented characters - incompatible?
Previous:From: Pavel StehuleDate: 2007-12-01 10:43:52
Subject: plpgsql, forc statement

pgsql-general by date

Next:From: Owen HartnettDate: 2007-12-01 18:08:30
Subject: Re: Linux v.s. Mac OS-X Performance
Previous:From: Ragnar HeilDate: 2007-12-01 16:35:41
Subject: Re: Postgres High Availablity Solution needed for hot-standby and load balancing

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