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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-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

Browse pgsql-general by date

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

Browse pgsql-hackers by date

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

Browse pgsql-patches by date

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