On Wed, Aug 17, 2005 at 06:46:20PM -0400, Tom Lane wrote: > "Greg Sabino Mullane" <[EMAIL PROTECTED]> writes: > > ERROR: error from Perl function: creation of Perl function failed: > > (in cleanup) Undefined subroutine &main::mksafefunc called at (eval 4) line > > 2. at (eval 4) line 2. > > I could not duplicate this in either 8.0 or HEAD branches. It looks > a bit like an old bug that we had in plperl, though. Are you sure your > plperl.so is up to date?
Could this be another "depends on the junk on your stack" bug? I get different results depending on the OS and version of PostgreSQL: 8.0.3 (from CVS), FreeBSD 4.11-STABLE, Perl 5.8.7 (from ports) * error with or without reconnect HEAD, FreeBSD 4.11-STABLE, Perl 5.8.7 (from ports) * success without reconnect, error with reconnect 8.0.3 (from CVS), Solaris 9, Perl 5.8.7 (from source) * error with or without reconnect HEAD, Solaris 9, Perl 5.8.7 (from source) * error with or without reconnect The configure options for all PostgreSQL builds are nearly identical except that the builds on FreeBSD don't have --enable-cassert. -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match