Postgres Pro
Downloads
Home   >   mailing lists

Re: plpgsql - Mailing list pgsql-general

From Tom Lane
Subject Re: plpgsql
Date
Msg-id 7928.1010521097@sss.pgh.pa.us
Whole thread Raw
In response to plpgsql  (Nick Haw <nick.haw@operagrp.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Dominic J. Eidson"
Date:
Subject: Re: Does Postgres support BLOB datatypes?
Next
From: Bill Cunningham
Date:
Subject: Re: [SQL] Need help