plpgsql

Nick Haw <nick.haw@operagrp.com> writes:

createlang plpgsql database1

I get this error message

ERROR: Load of file /usr/lib/pgsql/lib/plpgsql.so failed:
/usr/lib/pgsql/lib/plpgsql.so: undefined symbol: CurrentTriggerData
createlang: language installation failed

I'll bet /usr/lib/pgsql/lib/plpgsql.so is from PG 7.0 (or older),
and you're trying to load it into 7.1.

regards, tom lane

Nick Haw <nick.haw@operagrp.com> writes:

Hello all, been skulking around here in the background reading the threads
and waiting for a problem to come up and now I have one. I am trying to
"install" plpgsql on one of my databases. When I run the command

createlang plpgsql database1

I get this error message

ERROR: Load of file /usr/lib/pgsql/lib/plpgsql.so failed:
/usr/lib/pgsql/lib/plpgsql.so: undefined symbol: CurrentTriggerData
createlang: language installation failed

Sounds as if you may have a mismatch between the version of the shared
library and that of PG itself. What version are you using and how was
it installed?

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
--T. J. Jackson, 1863