createlang fails w/ 'undef ref to _SPI_restore_connection' on 8b5 on OSX 10.3.6 - Mailing list pgsql-general

From OpenMacNews
Subject createlang fails w/ 'undef ref to _SPI_restore_connection' on 8b5 on OSX 10.3.6
Date
Msg-id 1DC77A2E4292C814D3DE2D59@tiedgar.internal.presence-group.net
Whole thread Raw
Responses Re: createlang fails w/ 'undef ref to _SPI_restore_connection' on 8b5 on OSX 10.3.6  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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

pgsql-general by date:

Previous
From: Woodchuck Bill
Date:
Subject: Re: [ANNOUNCE] USENET vs Mailing Lists Poll ...
Next
From: Tom Lane
Date:
Subject: Re: Newbie question: returning rowtypes from a plpgsql function