Re: plpgsql

From: Doug McNaught <doug(at)wireboard(dot)com>
To: Nick Haw <nick(dot)haw(at)operagrp(dot)com>
Cc: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>, "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: plpgsql
Date: 2002-01-08 21:39:23
Message-ID: m3bsg4bjzo.fsf@varsoon.denali.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

Nick Haw <nick(dot)haw(at)operagrp(dot)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

In response to

  • plpgsql at 2002-01-08 17:07:42 from Nick Haw

Browse pgsql-general by date

  From Date Subject
Next Message Alaric B. Snell 2002-01-08 21:42:13 Query planner isn't using my indices
Previous Message Tom Lane 2002-01-08 21:32:12 Re: sequential scans and the like operator

Browse pgsql-novice by date

  From Date Subject
Next Message Jules Alberts 2002-01-09 14:57:49 location for pgdata
Previous Message Tom Lane 2002-01-08 20:18:17 Re: plpgsql