Thread: Undefined subroutine &main::spi_prepare

I have a PL/Perl stored procedure that's worked fine on my development
boxes but is suddenly failing when installed on a test machine.  Both my
test machines and the new machine are RHEL AS5.  The differences are the
test machine is 64-bit, and running Postgres 8.1.18 instead of my
development machine which is 32-bit and running Postgres 8.2.7.

The error in the postgresql log is:

ERROR:  error from Perl function: Undefined subroutine
&main::spi_prepare called at line 2.
LOG:  unexpected EOF on client connection

My first thought was that the postgresql-pl package wasn't installed,
but it appears to be there.  Does anyone else know what sort of
installation/configuration error could cause a failure like this?

Thanks.
-Tony

Tony Cebzanov <tonyceb@andrew.cmu.edu> writes:
> I have a PL/Perl stored procedure that's worked fine on my development
> boxes but is suddenly failing when installed on a test machine.  Both my
> test machines and the new machine are RHEL AS5.  The differences are the
> test machine is 64-bit, and running Postgres 8.1.18 instead of my
> development machine which is 32-bit and running Postgres 8.2.7.

I don't think spi_prepare existed in 8.1 plperl.

In general it's not a terribly good idea to develop on a newer PG
version than you plan to deploy on ...

            regards, tom lane