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: xxxxxx
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

Reply via email to