Thread: Load of file failed

Hello All,
         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/li
b/plpgsql.so: undefined symbol: SPI_lastoid
         All files are present in this directory. I want to know how to
solve this error.
Thanks and regards,
Vivek

_________________________________________________________________
Take this "News" quiz. Win cool prizes.
http://server1.msn.co.in/sp03/cnn/index.asp Click 'n play!

"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