Received: from y2k.state.il.us (y2k.state.il.us [163.191.171.44])
	by hub.org (8.9.3/8.9.3) with ESMTP id KAA84768
	for <pgsql-interfaces@postgreSQL.org>;
	Thu, 2 Sep 1999 10:00:52 -0400 (EDT)
	(envelope-from rob@y2k.state.il.us)
Received: from yk (yk [10.2.6.13])
	by y2k.state.il.us (8.9.3/Pro-8.9.3) with SMTP id IAA08840;
	Thu, 2 Sep 1999 08:55:37 -0500
Message-Id: <3.0.6.32.19990902085857.008fce30@y2k.state.il.us>
X-Sender: rob@y2k.state.il.us (Unverified)
X-Mailer: QUALCOMM Windows Eudora Light Version 3.0.6 (32)
Date: Thu, 02 Sep 1999 08:58:57 -0500
To: The Hermit Hacker <scrappy@hub.org>
From: Robert Hiltibidal <rob@y2k.state.il.us>
Subject: Re: [INTERFACES] FPK Pascal and Postgres
Cc: ken@ori-ind.com, pgsql-interfaces@postgreSQL.org
In-Reply-To: <Pine.BSF.4.10.9909011326050.8660-100000@thelab.hub.org>
References: <3.0.6.32.19990901103056.009043b0@y2k.state.il.us>
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"

Morning,

I installed FPK Pascal on another host last night. I ran into a similar
problem where the error message was:

testpg: error in loading shared libraries
libpq.so.2.0: cannot open shared object file: No such file or directory

I checked both the /etc/ld.so.conf files and the /etc/ppc386.cfg file. I
had the proper enteries in both files. 

The problem was in the postgress.pp file. The include statement was
originally:
{ $include "libpq/pqcomm.h"}

By changing it to the absolute path as listed below everything works great.
Its a bit early for benchmarks but I'm guestimating I'm seeing somewhere's
around 40% speed improvement over Perl. Perhaps today I'll make a benchmark
program and compare the results.

Although I will say it takes about 20 lines of code in perl and about 70
lines in pascal... tradeoff's...gotta love 'em.

{ $include "/usr/include/libpq/pqcomm.h"}


-Rob