Re: Load of file failed - Mailing list pgsql-admin

From Tom Lane
Subject Re: Load of file failed
Date
Msg-id 29888.1052483979@sss.pgh.pa.us
Whole thread Raw
In response to Load of file failed  ("vivek K." <vivek10@hotmail.com>)
List pgsql-admin
"vivek K." <vivek10@hotmail.com> writes:
>          while i was executing a trigger for insert into a table , I go this
>   error :
> ERROR:  Load of file /usr/local/pgsql/lib/plpgsql.so failed:
> /usr/local/pgsql/lib/plpgsql.so: undefined symbol: SPI_lastoid

This suggests a version mismatch, specifically that the plpgsql.so
library is for a newer version of Postgres than the server you are
running.  (Checking back, it appears that SPI_lastoid was added to
the backend in 7.1.)

            regards, tom lane


pgsql-admin by date:

Previous
From: "dlangschied"
Date:
Subject: Service names in postgres
Next
From: Bruno Wolff III
Date:
Subject: Re: Automatic shutdown from Linux.