Re: [GENERAL] createlang fails w/ 'undef ref to
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 of: FATAL: database files are incompatible with server DETAIL: The database cluster was initialized with CATALOG_VERSION_NO 200410111, but the server was compiled with CATALOG_VERSION_NO 200411041. HINT: It looks like you need to initdb. after re-initdb'ing and restarting, all's ok with 'createlang' ... inasmuch as i get no error & no log entries ... for all langs. i didna realize (and apparently missed in RTFM'ing) that initdb was necessary from beta-to-beta ... s, as usual, i created my own problem :S odd though that i was getting fatal errors, but still able to launch the db ... thanks for your patience & help! cheers, richard ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
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])
Re: [GENERAL] createlang fails w/ 'undef ref to
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 end, % postmaster --version postmaster (PostgreSQL) 8.0.0beta5 % ls -alt postgresql-8.0.0beta5.tar.gz -rw-r--r-- 1 devuser wheel 13501406 Nov 30 16:50 postgresql-8.0.0beta5.tar.gz % ls -alt /usr/local/pgsql/bin/postgres -rwxr-xr-x 1 devuser wheel 10725396 Nov 30 17:41 /usr/local/pgsql/bin/postgres % ls -alt /usr/local/pgsql/lib/plpgsql.so -rwxr-xr-x 1 devuser wheel 403892 Nov 30 17:44 /usr/local/pgsql/lib/plpgsql.so % createlang --version createlang (PostgreSQL) 8.0.0beta5 then, still, % createlang plpgsql template1 Password: xx 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 i _think_ i'm up to date ... thx again, richard ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
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
[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])