Thank you so much for your kind reply.
Your analysis sounds very reasonable. I checked my Perl version, it is "Perl 5.8.9 Build 826" which is the latest
versionin the series of 5.8.*.
The whole process of installation of Perl goes well without any something wrong. And I can run Perl command out of
Postgresqlvery well. So is this Perl version not compatible with Postgresql 8.3.7? And may I configure Perl somewhere
orsomething? When Perl is loaded, what will be executed by it?
"Substitution pattern not terminated at line 1." Souds like one regular expression. But I can not determine what will
beexecuted by Perl.
BR
Lucy
-----邮件原件-----
发件人: Robert Haas [mailto:robertmhaas@gmail.com]
发送时间: 2009年9月28日 10:19
收件人: Yaming Gu
抄送: pgsql-bugs@postgresql.org
主题: Re: [BUGS] Encounter shared memory error when running createlang command!
On Wed, Sep 23, 2009 at 11:44 PM, Yaming Gu <yaming.gu@w-oasis.com> wrote:
> 2009-09-24 10:50:55 HKT LOG: loaded library
> "$libdir/plugins/plugin_debugger.dll"
>
> 2009-09-24 10:50:59 HKT LOG: loaded library
> "$libdir/plugins/plugin_debugger.dll"
>
> Substitution pattern not terminated at line 1.
I'm very suspicious of this error message. "Substitution pattern not
terminated at line 1" sounds like an error message that is being
generated *by Perl*. I don't see that phrase anywhere in the
PostgreSQL sources. If that's true, that means that Perl is getting
loaded, but then immediately dying when it tries to compile
something-or-other that has a bad regular expression in there. Could
there be something wrong with your Perl installation? Can you launch
Perl from outside PostgreSQL OK?
Another possibility is that some of the Perl code that PL/perl tries
to execute during the load of Perl is not working for some reason.
What version of Perl do you have on your system? What happens if you
try to load plperlu?
...Robert