Re: Undefined subroutine &main::spi_prepare - Mailing list pgsql-general

From Tom Lane
Subject Re: Undefined subroutine &main::spi_prepare
Date
Msg-id 14693.1259772133@sss.pgh.pa.us
Whole thread Raw
In response to Undefined subroutine &main::spi_prepare  (Tony Cebzanov <tonyceb@andrew.cmu.edu>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Roles with passwords; SET ROLE ... WITH PASSWORD ?
Next
From: Tom Lane
Date:
Subject: Re: Roles with passwords; SET ROLE ... WITH PASSWORD ?