Christopher Kings-Lynne said: > >> 1 is not acceptable, and 2 kinda sucks. >> >> Please try adding this to SPI.xs, >> >> #ifndef aTHX_ >> #define aTHX_ >> #endif >> >> recompile and test by calling spi_exec_query with more than 2 >> arguments like this: > > Hmmm, compiled fine, but then I get this: > > -bash-2.05b$ createlang -d test plperl > ERROR: could not load library > "/home/chriskl/local/lib/postgresql/plperl.so": dlopen > '/home/chriskl/local/lib/postgresql/plperl.so' failed. > (/home/chriskl/local/lib/postgresql/plperl.so: Undefined symbol > "eval_pv") createlang: language installation failed: ERROR: could not > load library "/home/chriskl/local/lib/postgresql/plperl.so": dlopen > '/home/chriskl/local/lib/postgresql/plperl.so' failed. > (/home/chriskl/local/lib/postgresql/plperl.so: Undefined symbol > "eval_pv") >
progress is good .... We seem to have a mixture of old-style and new-style calls which needs to be cleaned up. I would relly appreciate some experienced eyes being cast over this, if there are any around. In the meantime, does this solve your problem?: #ifndef eval_pv #define eval_pv perl_eval_pv #endif cheers andrew ---------------------------(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