Обсуждение: 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