Re: Encounter shared memory error when running createlang command!

On Wed, Sep 23, 2009 at 11:44 PM, Yaming Gu <yaming(dot)gu(at)w-oasis(dot)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