One of my customer unable to install plpgsql
with next message:

www2(dms)~>psql -d www -c "select tst(); "
ERROR:  Load of file /usr/local/pgsql/lib/plpgsql.so failed: dlopen
'/usr/local/pgsql/lib/plpgsql.so' failed. (/usr/local/pgsql/lib/plpgsql.so:
Undefined symbol "SPI_tuptable")
www2(dms)~>

what does it mean?

Env:
FreeBSD www2.sptimes.ru 3.1-RELEASE FreeBSD 3.1-RELEASE #4: Tue Mar 23 13:18:41
MSK 1999     wplus@www2.sptimes.ru:/usr/src/sys/compile/SPTIMES  i386

Postgres 6.4.2 release

PS:
How about adding something like -a key to pg_version to report full
release and compile information?



---
Dmitry Samersoff, dms@wplus.net, ICQ:3161705
http://devnull.wplus.net
* there will come soft rains ...

Wed, 05 May 1999 16:58:57 +0400 (MSD)
Dmitry Samersoff <dms@wplus.net>
What does it mean?
>
> One of my customer unable to install plpgsql
> with next message:
>
> www2(dms)~>psql -d www -c "select tst(); "
> ERROR:  Load of file /usr/local/pgsql/lib/plpgsql.so failed: dlopen
> '/usr/local/pgsql/lib/plpgsql.so' failed. (/usr/local/pgsql/lib/plpgsql.so:
> Undefined symbol "SPI_tuptable")
> www2(dms)~>
>
> what does it mean?
>
> Env:
> FreeBSD www2.sptimes.ru 3.1-RELEASE FreeBSD 3.1-RELEASE #4: Tue Mar 23 13:18:41
> MSK 1999     wplus@www2.sptimes.ru:/usr/src/sys/compile/SPTIMES  i386
>
> Postgres 6.4.2 release

    Doesn't  look  to  me like a v6.4.2. SPI_tuptable is a global
    pointer which is defined in .../backend/executor/spi.c.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#======================================== jwieck@debis.com (Jan Wieck) #



Thu, 6 May 1999 14:24:02 +0200 (MET DST)
jwieck@debis.com (Jan Wieck)
Re: [HACKERS] What does it mean?
 One of my customer unable to install plpgsql
with next message:
 
www2(dms)~>psql -d www -c "select tst(); "
ERROR:  Load of file /usr/local/pgsql/lib/plpgsql.so failed: dlopen
'/usr/local/pgsql/lib/plpgsql.so' failed. (/usr/local/pgsql/lib/plpgsql.so:
Undefined symbol "SPI_tuptable")
www2(dms)~>

This problem exists onlty on FreeBSD 3.1
the same sources build on 2.2.8 works properly.
 
what does it mean?
 
Env:
 FreeBSD www2.sptimes.ru 3.1-RELEASE FreeBSD 3.1-RELEASE #4: Tue Mar 23
 13:18:41
 MSK 1999     wplus@www2.sptimes.ru:/usr/src/sys/compile/SPTIMES  i386
 
Postgres 6.4.2 release
 
PS:
 How about adding something like -a key to pg_version to report full
 release and compile information?
 

---
Dmitry Samersoff, dms@wplus.net, ICQ:3161705
http://devnull.wplus.net
* there will come soft rains ...

Sun, 09 May 1999 19:23:53 +0400 (MSD)
Dmitry Samersoff <dms@wplus.net>
Problem installing plpgsql
Dmitry Samersoff wrote:

>
>  One of my customer unable to install plpgsql
> with next message:
>
> www2(dms)~>psql -d www -c "select tst(); "
> ERROR:  Load of file /usr/local/pgsql/lib/plpgsql.so failed: dlopen
> '/usr/local/pgsql/lib/plpgsql.so' failed. (/usr/local/pgsql/lib/plpgsql.so:
> Undefined symbol "SPI_tuptable")
> www2(dms)~>
>
> This problem exists onlty on FreeBSD 3.1
> the same sources build on 2.2.8 works properly.
>
> what does it mean?

    It  means  that  the  dynamic  loader isn't able to resolve a
    reference  to  the  global  symbol  "SPI_tuptable"  from  the
    PL/pgSQL   shared   object  into  the  backend.   The  symbol
    "SPI_tuptable" is declared in  .../src/backend/executor/spi.c
    as

        DLLIMPORT SPITupleTable *SPI_tuptable;

    Since  this  symbol  is  referenced from another place in the
    backend's static code (in ruleutils.c) I'm  pretty  sure  the
    symbol  is  there.  It must be a problem with the FreeBSD 3.1
    dynamic loader.

>
> Env:
>  FreeBSD www2.sptimes.ru 3.1-RELEASE FreeBSD 3.1-RELEASE #4: Tue Mar 23
>  13:18:41
>  MSK 1999     wplus@www2.sptimes.ru:/usr/src/sys/compile/SPTIMES  i386
>
> Postgres 6.4.2 release


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#======================================== jwieck@debis.com (Jan Wieck) #



Mon, 10 May 1999 17:11:31 +0200 (MET DST)
jwieck@debis.com (Jan Wieck)
Re: [HACKERS] Problem installing plpgsql
On 10-May-99 Jan Wieck wrote:
> Dmitry Samersoff wrote:
> 
>>
>>  One of my customer unable to install plpgsql
>> with next message:
>>
>> www2(dms)~>psql -d www -c "select tst(); "
>> ERROR:  Load of file /usr/local/pgsql/lib/plpgsql.so failed: dlopen
>> '/usr/local/pgsql/lib/plpgsql.so' failed. (/usr/local/pgsql/lib/plpgsql.so:
>> Undefined symbol "SPI_tuptable")
>> www2(dms)~>
>>
>> This problem exists onlty on FreeBSD 3.1

>     Since  this  symbol  is  referenced from another place in the
>     backend's static code (in ruleutils.c) I'm  pretty  sure  the
>     symbol  is  there.  It must be a problem with the FreeBSD 3.1
>     dynamic loader.

OK, I see.

Does any body have the same problem and is there known solution?

---
Dmitry Samersoff, dms@wplus.net, ICQ:3161705
http://devnull.wplus.net
* there will come soft rains ...

Tue, 11 May 1999 10:00:09 +0400 (MSD)
Dmitry Samersoff <dms@wplus.net>
Re: [HACKERS] Problem installing plpgsql