[GENERAL] createlang fails w/ 'undef ref to _SPI_restore_connection' on 8b5 on OSX 10.3.6
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 ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [GENERAL] createlang fails w/ 'undef ref to _SPI_restore_connection' on 8b5 on OSX 10.3.6
OpenMacNews [EMAIL PROTECTED] writes: 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 You seem to be trying to load a current plpgsql.so into a less than current backend. SPI_restore_connection() was just added a few days ago ... regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] createlang fails w/ 'undef ref to _SPI_restore_connection' on 8b5 on OSX 10.3.6
OpenMacNews [EMAIL PROTECTED] writes: i _think_ i'm up to date ... Maybe you didn't restart your beta4-or-older postmaster after updating? SPI_restore_connection definitely exists in the beta5 sources ... regards, tom lane ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])