Thread: 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