Re: BUG #1831: plperl gives error after reconnect. - Mailing list pgsql-bugs

From Michael Fuhr
Subject Re: BUG #1831: plperl gives error after reconnect.
Date
Msg-id 20050820045717.GA41722@winnie.fuhr.org
Whole thread Raw
In response to Re: BUG #1831: plperl gives error after reconnect.  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #1831: plperl gives error after reconnect.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
On Sat, Aug 20, 2005 at 12:03:46AM -0400, Tom Lane wrote:
> I'm wondering if this is Perl version dependent.  I've tried with
>
> Fedora Core 3:
> This is perl, v5.8.5 built for i386-linux-thread-multi
> Darwin 10.4.2:
> This is perl, v5.8.6 built for darwin-thread-multi-2level
>
> with no failures observed... what are you guys using?

FreeBSD 4.11-STABLE/x86
This is perl, v5.8.7 built for i386-freebsd-64int
(built from ports directory with gcc 2.95.4)

Solaris 9/sparc
This is perl, v5.8.7 built for sun4-solaris
(built from source with gcc 3.4.2)

I just built PL/Perl on the Solaris box with Perl 5.8.6 and got the
same results.  I used ldd to verify that plperl.so was linked against
5.8.6, and I had one of the functions return Perl's $] variable just
to make sure.

I see that both of your Perl version strings have "thread-multi"
whereas neither of mine do.  I don't know if that's relevant, but
it's something different about the Perl builds.

% perl -V | grep thread
    usethreads=undef use5005threads=undef useithreads=undef usemultiplicity=undef

You're doing the reconnect, right?  The error appears to happen
during the SPI call if the called function hasn't been compiled
yet, either by being previously called or by being validated during
creation.

--
Michael Fuhr

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #1831: plperl gives error after reconnect.
Next
From: Tom Lane
Date:
Subject: Re: BUG #1831: plperl gives error after reconnect.