From: vedm
Subject: CLSQL can't load shared library libpq (ACL Express Free 8.0, Window XP, Postgresql 8.1)
Date: Thu, 14 Sep 2006 15:55:42 +0000
Message-ID: <u7udndOZheby5pTYnZ2dnUVZ_rqdnZ2d@giganews.com>

I sent this to the CLSQL mailing list but got no response, so:

Here's the message I get when I execute clsql:connect:

==
Couldn't load foreign library "libpq". (searched
CLSQL-SYS:*FOREIGN-LIBRARY-SEARCH-PATHS*)
   [Condition of type SIMPLE-ERROR]
==

And here is my search path:

==
CL-USER> clsql:*foreign-library-search-paths*
(#P"c:\\Program Files\\PostgreSQL\\8.1\\lib\\"
 #P"c:\\Program Files\\PostgreSQL\\8.1\\lib\\ms\\"
 #P"c:\\Program Files\\PostgreSQL\\8.1\\bin\\"
 #P"C:\\.asdf-install-dir\\site\\clsql-3.7.1\\uffi\\")
==

In those Postgresql directories I can see libpq.a under "lib", libpq.lib
under "lib/ms", and libpq.dll under "bin".

What am I doing wrong?


-- 
vedm

• Re: CLSQL can't load shared library libpq (ACL Express Free 8.0, Window XP, Postgresql 8.1) jmckitrick
  • Re: CLSQL can't load shared library libpq (ACL Express Free 8.0, Window XP, Postgresql 8.1) vedm

From: jmckitrick
Subject: Re: CLSQL can't load shared library libpq (ACL Express Free 8.0, Window XP, Postgresql 8.1)
Date: Fri, 15 Sep 2006 06:26:56 +0000
Message-ID: <1158301616.727910.33300@p79g2000cwp.googlegroups.com>

vedm wrote:
> ==
> Couldn't load foreign library "libpq". (searched
> CLSQL-SYS:*FOREIGN-LIBRARY-SEARCH-PATHS*)
>    [Condition of type SIMPLE-ERROR]
> ==
> In those Postgresql directories I can see libpq.a under "lib", libpq.lib
> under "lib/ms", and libpq.dll under "bin".

Well, let's see if I can remember how I solved this one... first, make
sure that when you compiled CLSQL during installation, that the
postgresql part of it compiled ok... it should have found the
library.... You know, I can't remember now what it was.  Maybe someone
else can help here.  I just remember getting it to work by chance, and
wishing I'd written down the procedure I followed.

Here's what I've done since then: when you connect, use :database-type
:postgresql-socket

The socket interface is much easier to use, no libs required to
interface to the DB.

From: vedm
Subject: Re: CLSQL can't load shared library libpq (ACL Express Free 8.0, Window XP, Postgresql 8.1)
Date: Fri, 15 Sep 2006 11:53:14 +0000
Message-ID: <b42dncEh26mECZfYnZ2dnUVZ_vWdnZ2d@giganews.com>

"jmckitrick" <···········@yahoo.com> writes:

> vedm wrote:
>> ==
>> Couldn't load foreign library "libpq". (searched
>> CLSQL-SYS:*FOREIGN-LIBRARY-SEARCH-PATHS*)
>>    [Condition of type SIMPLE-ERROR]
>> ==
>> In those Postgresql directories I can see libpq.a under "lib", libpq.lib
>> under "lib/ms", and libpq.dll under "bin".
>
> Well, let's see if I can remember how I solved this one... first, make
> sure that when you compiled CLSQL during installation, that the

I install it with ASDF-INSTALL.


> postgresql part of it compiled ok... it should have found the
> library.... You know, I can't remember now what it was.  Maybe someone
> else can help here.  I just remember getting it to work by chance, and
> wishing I'd written down the procedure I followed.
>
> Here's what I've done since then: when you connect, use :database-type
> :postgresql-socket
>
> The socket interface is much easier to use, no libs required to
> interface to the DB.

Thanks, this seems to work.
>

-- 
vedm