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

Re: BUG #1831: plperl gives error after reconnect.

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Greg Sabino Mullane <greg(at)turnstep(dot)com>,pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1831: plperl gives error after reconnect.
Date: 2005-08-20 04:57:17
Message-ID: 20050820045717.GA41722@winnie.fuhr.org (view raw or flat)
Thread:
Lists: 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

In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2005-08-20 05:14:02
Subject: Re: BUG #1831: plperl gives error after reconnect.
Previous:From: Tom LaneDate: 2005-08-20 04:22:05
Subject: Re: BUG #1831: plperl gives error after reconnect.

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