| From: | OpenMacNews <pgsql-general(dot)20(dot)openmacnews(at)spamgourmet(dot)com> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Subject: | Re: createlang fails w/ 'undef ref to |
| Date: | 2004-12-01 04:36:52 |
| Message-ID: | 5DF5CFA987259DC64782BF96@tiedgar.internal.presence-group.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc G. Fournier | 2004-12-01 04:46:43 | Re: Upcoming Changes to News Server ... |
| Previous Message | Jamie Deppeler | 2004-12-01 04:20:17 | Trigger problem 2 |