HSQL Linking Problem with ghc6

[Charles Perkins]

Hello Haskellians,

I have been looking for a way to get ghc-compiled haskell programs to
talk to a PostgreSQL database, and HSQL seems to be exactly what I
need... And what's more, it appears to have downloaded and installed
with minimal hassle...

Alas (and I am sure this is a problem with my own lack of knowledge or
misconfiguration of my system) I can't get ghc to link my program to the
HSQL libHSSql.a library. At least I think that is the problem.

On my debian-stable system, with some packages and libraries upgraded to
-testing so I could install ghc6, I downloaded HSQL 1.0 from sourceforge
and then ./configured with --enable-postgress and told it to make and
then make -install the HSQL package. When I put an import HSQL statement
in my program ghc compiles it without errors but the Linking phase
reports the following (my program name is EnvPassed:)

Linking ...
EnvPassed.o: In function `__stginit_main_':
EnvPassed.o(.text+0x25): undefined reference to `__stginit_HSQL_'
Collect2: ld returned 1 exit status

I get the same error when I do a standard compile and when I specify the
library to link to as follows: ghc --make EnvPassed.hs -o EnvPassed
-lHSsql -L/software/HSQL/

(I had expanded and built HSQL in the /software directory.)

Am I doing something stupid? What should I check for this kind of error?

Any help would be appreciated.

Chuck