Tony Cebzanov <tonyceb(at)andrew(dot)cmu(dot)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