Re: createlang fails w/ 'undef ref to

Поиск
Список
Период
Сортировка
От OpenMacNews
Тема Re: createlang fails w/ 'undef ref to
Дата
Msg-id 5DF5CFA987259DC64782BF96@tiedgar.internal.presence-group.net
обсуждение исходный текст
Ответ на Re: createlang fails w/ 'undef ref to _SPI_restore_connection' on 8b5 on OSX 10.3.6  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: createlang fails w/ 'undef ref to _SPI_restore_connection' on 8b5 on OSX 10.3.6  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Jamie Deppeler
Дата:
Сообщение: Trigger problem 2
Следующее
От: Woodchuck Bill
Дата:
Сообщение: Re: [ANNOUNCE] USENET vs Mailing Lists Poll ...