Postgres Pro
Downloads
Home   >   mailing lists

Thread: PLPerl on Windows?

PLPerl on Windows?

From
"Rod Taylor"
Date:
It's windows 2000, Postgresql 7.2 release ontop of CYGWIN_NT-5.0
JESTER 1.3.9(0.51/3/2) 2002-01-21 12:48 i686 unknown.  It compiles
(and runs) find without the --with-perl.  Tried both perl compiled
from sourcecode and the pre-compiled version that comes with cygwin.


./configure  --with-perl --prefix=/usr/local --enable-multibyte --enab
le-locale --enable-recode
.
.
.
make
.
.
.
rm -f blib/arch/auto/plperl/plperl.dll
LD_RUN_PATH="" ld2  -s -L/usr/local/lib plperl.o eloglvl.o
SPI.o -s -L/usr/local/lib
/usr/lib/perl5/5.6.1/cygwin-multi/auto/DynaLoader/DynaLoader.a -L
/usr/lib/perl5/5.6.1/cygwin-multi/CORE -lcrypt -o
blib/arch/auto/plperl/plperl.dll
/usr/lib/perl5/5.6.1/cygwin-multi/CORE/libperl5_6_1.a
dllwrap --dllname plperl.dll --driver-name gcc --dlltool
dlltool --export-all-symbols --as as --output-def
libplperl.def --output-lib libplperl.a \
-s -L/usr/local/lib plperl.o eloglvl.o SPI.o -s -L/usr/local/lib
/usr/lib/perl5/5.6.1/cygwin-multi/auto/DynaLoader/DynaLoader.a -L/usr/
lib/perl5/5.6.1
/cygwin-multi/CORE -lcrypt
/usr/lib/perl5/5.6.1/cygwin-multi/CORE/libperl5_6_1.a
dllwrap: no export definition file provided
dllwrap: creating one, but that may not be what you want
plperl.o(.text+0x2):plperl.c: undefined reference to
`_imp__TopMemoryContext'
plperl.o(.text+0x1a):plperl.c: undefined reference to `fmgr_info_cxt'
plperl.o(.text+0x270):plperl.c: undefined reference to `elog'
plperl.o(.text+0x361):plperl.c: undefined reference to `SPI_connect'
plperl.o(.text+0x375):plperl.c: undefined reference to `elog'
plperl.o(.text+0x39c):plperl.c: undefined reference to `elog'
plperl.o(.text+0x9b5):plperl.c: undefined reference to `elog'
plperl.o(.text+0x9cc):plperl.c: undefined reference to `elog'
plperl.o(.text+0xaa6):plperl.c: undefined reference to `elog'
plperl.o(.text+0xe76):plperl.c: undefined reference to `FunctionCall3'
plperl.o(.text+0xf07):plperl.c: undefined reference to `pfree'
plperl.o(.text+0x100f):plperl.c: undefined reference to `elog'
plperl.o(.text+0x1341):plperl.c: undefined reference to `elog'
plperl.o(.text+0x1440):plperl.c: undefined reference to
`_imp__Warn_restart'
plperl.o(.text+0x1450):plperl.c: undefined reference to
`_imp__Warn_restart'
plperl.o(.text+0x145f):plperl.c: undefined reference to
`_imp__Warn_restart'
plperl.o(.text+0x1476):plperl.c: undefined reference to
`_imp__Warn_restart'
plperl.o(.text+0x148c):plperl.c: undefined reference to
`_imp__Warn_restart'
plperl.o(.text+0x14bb):plperl.c: more undefined references to
`_imp__Warn_restart' follow
plperl.o(.text+0x1506):plperl.c: undefined reference to `SPI_finish'
plperl.o(.text+0x151d):plperl.c: undefined reference to `elog'
plperl.o(.text+0x15c0):plperl.c: undefined reference to
`FunctionCall3'
plperl.o(.text+0x15ea):plperl.c: undefined reference to
`_imp__Warn_restart'
plperl.o(.text+0x1615):plperl.c: undefined reference to
`_imp__Warn_restart'
plperl.o(.text+0x163d):plperl.c: undefined reference to
`_imp__Warn_restart'
plperl.o(.text+0x18d4):plperl.c: undefined reference to
`SearchSysCache'
plperl.o(.text+0x18ee):plperl.c: undefined reference to `elog'
plperl.o(.text+0x1a83):plperl.c: undefined reference to `elog'
plperl.o(.text+0x1ad9):plperl.c: undefined reference to
`SearchSysCache'
plperl.o(.text+0x1b15):plperl.c: undefined reference to `elog'
plperl.o(.text+0x1b32):plperl.c: undefined reference to
`ReleaseSysCache'
plperl.o(.text+0x1b61):plperl.c: undefined reference to
`SearchSysCache'
plperl.o(.text+0x1ba8):plperl.c: undefined reference to `elog'
plperl.o(.text+0x1be7):plperl.c: undefined reference to `elog'
plperl.o(.text+0x1c0f):plperl.c: undefined reference to
`ReleaseSysCache'
plperl.o(.text+0x1c68):plperl.c: undefined reference to
`SearchSysCache'
plperl.o(.text+0x1cb0):plperl.c: undefined reference to `elog'
plperl.o(.text+0x1d0b):plperl.c: undefined reference to
`ReleaseSysCache'
plperl.o(.text+0x1d30):plperl.c: undefined reference to `textout'
plperl.o(.text+0x1d35):plperl.c: undefined reference to
`DirectFunctionCall1'
plperl.o(.text+0x1d5a):plperl.c: undefined reference to `pfree'
plperl.o(.text+0x1d90):plperl.c: undefined reference to `elog'
plperl.o(.text+0x1dea):plperl.c: undefined reference to
`ReleaseSysCache'
plperl.o(.text+0x1f71):plperl.c: undefined reference to
`nocachegetattr'
plperl.o(.text+0x1fad):plperl.c: undefined reference to
`nocachegetattr'
plperl.o(.text+0x1fc4):plperl.c: undefined reference to
`heap_getsysattr'
plperl.o(.text+0x2010):plperl.c: undefined reference to
`SearchSysCache'
plperl.o(.text+0x2039):plperl.c: undefined reference to `elog'
plperl.o(.text+0x2054):plperl.c: undefined reference to
`ReleaseSysCache'
plperl.o(.text+0x206f):plperl.c: undefined reference to
`OidFunctionCall3'
plperl.o(.text+0x2090):plperl.c: undefined reference to `pfree'
SPI.o(.text+0x253):SPI.c: undefined reference to `elog'
collect2: ld returned 1 exit status
dllwrap: gcc exited with status 1
perlld: *** system() failed to execute
dllwrap --dllname plperl.dll --driver-name gcc --dlltool
dlltool --export-all-symbols --as as --output-def
libplperl.def --output-lib libplperl.a \
-s -L/usr/local/lib plperl.o eloglvl.o SPI.o -s -L/usr/local/lib
/usr/lib/perl5/5.6.1/cygwin-multi/auto/DynaLoader/DynaLoader.a -L/usr/
lib/perl5/5.6.1
/cygwin-multi/CORE -lcrypt
/usr/lib/perl5/5.6.1/cygwin-multi/CORE/libperl5_6_1.a

make[4]: *** [blib/arch/auto/plperl/plperl.dll] Error 1
make[4]: Leaving directory
`/home/rbt/temp/postgresql-7.2/src/pl/plperl'
make[3]: *** [all] Error 2
make[3]: Leaving directory
`/home/rbt/temp/postgresql-7.2/src/pl/plperl'
make[2]: *** [all] Error 2
make[2]: Leaving directory `/home/rbt/temp/postgresql-7.2/src/pl'
make[1]: *** [all] Error 2
make[1]: Leaving directory `/home/rbt/temp/postgresql-7.2/src'
make: *** [all] Error 2

--
Rod Taylor

Your eyes are weary from staring at the CRT. You feel sleepy. Notice
how restful it is to watch the cursor blink. Close your eyes. The
opinions stated above are yours. You cannot imagine why you ever felt
otherwise.

Re: PLPerl on Windows?

From
Jason Tishler
Date:
Rod,

On Sun, Feb 10, 2002 at 07:31:57PM -0500, Rod Taylor wrote:
> It's windows 2000, Postgresql 7.2 release ontop of CYGWIN_NT-5.0
> JESTER 1.3.9(0.51/3/2) 2002-01-21 12:48 i686 unknown.  It compiles
> (and runs) find without the --with-perl.  Tried both perl compiled
> from sourcecode and the pre-compiled version that comes with cygwin.
>
> ./configure  --with-perl ...
>
> make
>
> [snip]
> plperl.o(.text+0x2):plperl.c: undefined reference to `_imp__TopMemoryContext'
> plperl.o(.text+0x1a):plperl.c: undefined reference to `fmgr_info_cxt'
> plperl.o(.text+0x270):plperl.c: undefined reference to `elog'
> [snip]

See the following:

    http://archives.postgresql.org/pgsql-patches/2002-02/msg00029.php

When I release Cygwin PostgreSQL 7.2 it will contain this patch if it is
accepted into PostgreSQL CVS.

Jason

Re: PLPerl on Windows?

From
"Rod Taylor"
Date:
Between the patch and that ipc daemon it's installed, stuffs working
good now.

Should note that I can't seem to use the local socket connection --
but TCP/IP works great.

Thanks for the hand.
--
Rod Taylor

This message represents the official view of the voices in my head

----- Original Message -----
From: "Jason Tishler" <jason@tishler.net>
To: "Rod Taylor" <rbt@zort.ca>
Cc: <pgsql-cygwin@postgresql.org>
Sent: Sunday, February 10, 2002 10:02 PM
Subject: Re: [CYGWIN] PLPerl on Windows?


> Rod,
>
> On Sun, Feb 10, 2002 at 07:31:57PM -0500, Rod Taylor wrote:
> > It's windows 2000, Postgresql 7.2 release ontop of CYGWIN_NT-5.0
> > JESTER 1.3.9(0.51/3/2) 2002-01-21 12:48 i686 unknown.  It compiles
> > (and runs) find without the --with-perl.  Tried both perl compiled
> > from sourcecode and the pre-compiled version that comes with
cygwin.
> >
> > ./configure  --with-perl ...
> >
> > make
> >
> > [snip]
> > plperl.o(.text+0x2):plperl.c: undefined reference to
`_imp__TopMemoryContext'
> > plperl.o(.text+0x1a):plperl.c: undefined reference to
`fmgr_info_cxt'
> > plperl.o(.text+0x270):plperl.c: undefined reference to `elog'
> > [snip]
>
> See the following:
>
>
http://archives.postgresql.org/pgsql-patches/2002-02/msg00029.php
>
> When I release Cygwin PostgreSQL 7.2 it will contain this patch if
it is
> accepted into PostgreSQL CVS.
>
> Jason
>

Re: PLPerl on Windows?

From
Jason Tishler
Date:
Rod,

On Sun, Feb 10, 2002 at 11:14:18PM -0500, Rod Taylor wrote:
> Between the patch and that ipc daemon it's installed, stuffs working
> good now.

I'm glad that it's working for your now.

> Should note that I can't seem to use the local socket connection --
> but TCP/IP works great.

I use AF_UNIX sockets all the time.  Send detailed error messages to
the list if you wish to debug further.

> Thanks for the hand.

You are welcome.

Jason