Bug in PL/Perl makefile

Started by David Jack Olrikabout 26 years ago3 messagesbugs
Jump to latest
#1David Jack Olrik
david@olrik.dk

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
#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: David Jack Olrik (#1)
Re: [BUGS] Bug in PL/Perl makefile

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

#3Bruce Momjian
bruce@momjian.us
In reply to: David Jack Olrik (#1)
Re: [BUGS] Bug in PL/Perl makefile

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.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 ]

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