createlang fails w/ 'undef ref to _SPI_restore_connection' on 8b5 on OSX 10.3.6

From: OpenMacNews <pgsql-general(dot)20(dot)openmacnews(at)spamgourmet(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: createlang fails w/ 'undef ref to _SPI_restore_connection' on 8b5 on OSX 10.3.6
Date: 2004-12-01 03:27:39
Message-ID: 1DC77A2E4292C814D3DE2D59@tiedgar.internal.presence-group.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi all,

i've a successful install of pgsql 8b5 on OSX 10.3.6.

trying to install pl/pgsql:

% createlang plpgsql template1

results in an immediate error:

createlang: language installation failed: ERROR: could not load library
"/usr/local/pgsql/lib/plpgsql.so": dyld: /usr/local/pgsql/bin/postmaster
Undefined symbols:
/usr/local/pgsql/lib/plpgsql.so undefined reference to
_SPI_restore_connection expected to be defined in the executable

a similar error is generated by attempts to install pl/tcl, pl/perl or pl/python

googl'ing on "SPI_restore_connection" results in 0 hits. nada.

suggestions as to where to start?

thx,

richard

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-12-01 03:58:11 Re: Newbie question: returning rowtypes from a plpgsql function
Previous Message Woodchuck Bill 2004-12-01 02:39:50 Re: USENET vs Mailing Lists Poll ...