Re: [GENERAL] createlang fails w/ 'undef ref to

2004-11-30 Thread OpenMacNews
Maybe you didn't restart your beta4-or-older postmaster after updating? SPI_restore_connection definitely exists in the beta5 sources ... all ok now. restarting wasn't doing the trick ... same errors. still able to access/read/write to my db's but nada else. but, looking in my logs i noted a slew

Re: [GENERAL] createlang fails w/ 'undef ref to _SPI_restore_connection' on 8b5 on OSX 10.3.6

2004-11-30 Thread Tom Lane
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)

Re: [GENERAL] createlang fails w/ 'undef ref to

2004-11-30 Thread OpenMacNews
hi tom, thx for the reply =) 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 ... just getting used to pgsql terminology, but i presume by 'backend' you simply mean version of pgsql iteslf, yes? to that en

Re: [GENERAL] createlang fails w/ 'undef ref to _SPI_restore_connection' on 8b5 on OSX 10.3.6

2004-11-30 Thread Tom Lane
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_rest

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

2004-11-30 Thread OpenMacNews
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/post