Bug in PL/Perl makefile
Your name : David Jack Olrik
Your email address : david@olrik.dk
System Configuration
---------------------
Architecture (example: Intel Pentium) : Intel Pentium III
Operating System (example: Linux 2.0.26 ELF) : Linux 2.2.14 ELF
PostgreSQL version (example: PostgreSQL-6.5.1): PostgreSQL-7.0beta1
Compiler used (example: gcc 2.8.0) : gcc 2.95.2
Please enter a FULL description of your problem:
------------------------------------------------
pl/perl does not work.
Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
install pl/perl and create this function:
CREATE FUNCTION addints(int4, int4) RETURNS int4 AS '
return $_[0] + $_[1]
' LANGUAGE 'plperl';
Then select from it:
select addints(3,4);
Result:
ERROR: Load of file /usr/local/pgsql/lib/plperl.so failed:
/usr/local/pgsql/lib/plperl.so: undefined symbol: elog_DEBUG
If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------
Missing .o file in make file. Patchfile attached with this mail fixes the
problem!
--
Best regards,
David Jack Olrik <david@olrik.dk> http://david.olrik.dk
[ Linux: Because rebooting is for adding new hardware ]
Attachments:
Makefile.PL.patchtext/plain; charset=US-ASCII; name=Makefile.PL.patchDownload+2-2
David Jack Olrik <david@olrik.dk> writes:
Missing .o file in make file. Patchfile attached with this mail fixes the
problem!
David, the plperl makefile has been completely rewritten by Mark Hollomon
in the last couple days. I have not had time yet to check it and commit
it to CVS, but I am attaching what he sent me; would you like to try it?
regards, tom lane
This has been fixed by the plperl maintainer. Beta tomorrow should show
the new code.
Your name : David Jack Olrik
Your email address : david@olrik.dkSystem Configuration
---------------------
Architecture (example: Intel Pentium) : Intel Pentium IIIOperating System (example: Linux 2.0.26 ELF) : Linux 2.2.14 ELF
PostgreSQL version (example: PostgreSQL-6.5.1): PostgreSQL-7.0beta1
Compiler used (example: gcc 2.8.0) : gcc 2.95.2
Please enter a FULL description of your problem:
------------------------------------------------
pl/perl does not work.Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
install pl/perl and create this function:CREATE FUNCTION addints(int4, int4) RETURNS int4 AS '
return $_[0] + $_[1]
' LANGUAGE 'plperl';Then select from it:
select addints(3,4);
Result:
ERROR: Load of file /usr/local/pgsql/lib/plperl.so failed:
/usr/local/pgsql/lib/plperl.so: undefined symbol: elog_DEBUGIf you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------
Missing .o file in make file. Patchfile attached with this mail fixes the
problem!--
Best regards,
David Jack Olrik <david@olrik.dk> http://david.olrik.dk
[ Linux: Because rebooting is for adding new hardware ]
Content-Description: fix for bad makefile
[Attachment, skipping...]
--
Bruce Momjian | http://www.op.net/~candle
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From bouncefilter Thu Mar 2 05:45:53 2000
Received: from mark.desktop.knowledge.com (mark.desktop.knowledge.com
[195.40.167.197]) by hub.org (8.9.3/8.9.3) with ESMTP id FAA04053
for <pgsql-general@postgresql.org>; Thu, 2 Mar 2000 05:45:28 -0500 (EST)
(envelope-from mark.jewiss@knowledge.com)
Received: from localhost (mark@localhost)
by mark.desktop.knowledge.com (8.9.3/8.9.3) with ESMTP id KAA12193
for <pgsql-general@postgresql.org>; Thu, 2 Mar 2000 10:45:23 GMT
X-Authentication-Warning: mark.desktop.knowledge.com: mark owned process doing
-bs
Date: Thu, 2 Mar 2000 10:45:23 +0000 (GMT)
From: Mark Jewiss <mark.jewiss@knowledge.com>
Sender: mark@mark.desktop.knowledge.com
To: pgsql-general@postgresql.org
Subject: Version 7.0 beta problem
Message-ID:
<Pine.BSO.4.21.0003021043470.25133-100000@mark.desktop.knowledge.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
Hello,
Have run a full installation process for this twice now, and have
experienced the same problem both times: a psql binary is not built.
I've got around this by using the old 6.5.3 one, but still...
Running on OpenBSD 2.6.
If you need any files or logs from me, let me know - I can redo this in
full if required.
Regards,
Mark.
--
Mark Jewiss
Knowledge Matters Limited
http://www.knowledge.com