Re: Postgres 7.1RC4 ecpg can't find sqlca

4/14/01 00:08:14, Jason Tishler <Jason.Tishler@dothill.com> wrote:

>
>On Fri, Apr 13, 2001 at 11:02:23PM +0200, Michael Lemke wrote:
>> With the latest postgres release that came lately with cygwin I made my
>> very first attempt at writng an ESQL program (actually, at the moment it
>> is just something I dowloaded).  Now when I link it can't find sqlca:
>>
>> michael> gcc -I /usr/include/postgresql/  esql.c -lecpg -lpq
>> /f/cygwin~1/tmp/ccbnOeiG.o(.text+0x203):esql.c: undefined reference to `sqlca'
>> /f/cygwin~1/tmp/ccbnOeiG.o(.text+0x292):esql.c: undefined reference to `sqlca'
>> collect2: ld returned 1 exit status
>>
>> ecpg made the declaration of sqlca
>>
>>   extern struct sqlca sqlca;
>
>I believe that the above is a bug in sqlca.h.  My WAG (without actually
>trying this) is that the above should be replaced by the following:
>
>#ifdef __CYGWIN__
>    extern __declspec(dllimport) struct sqlca sqlca;
>#else
>    extern struct sqlca sqlca;
>

Jason,

thanks a lot.  That did the trick.  I didn't try the one below.   It's up
to the experts to decide which way to go.

>or by
>
>#ifdef __CYGWIN__
>    extern DLLIMPORT struct sqlca sqlca;
>#else
>    extern struct sqlca sqlca;
>
>if c.h can be safely included.
>
>> I recompiled postgres and skipped stripping of the libraries.  Then I find
>> sqlca in ecpg.dll:
>>
>> michael> nm /usr/bin/ecpg.dll | grep sqlca
>> c0586864 T _init_sqlca
>> c0587000 D _sqlca
>> c05870b0 d _sqlca_init
>
>Don't worry sqlca *is* exported from ecpg.dll:
>
>    $ objdump -p /usr/bin/ecpg.dll | fgrep sqlca
>            [  28] init_sqlca
>            [  29] sqlca
>
>> but not in libecpg.a:
>>
>> michael> nm /usr/lib/libecpg.a | grep sqlca
>> 00000000 I __imp__sqlca
>> 00000000 I __imp__init_sqlca
>> 00000000 T _init_sqlca
>
>Actually, sqlca *is* in the import library but it is called
>"__imp__sqlca" as it should be.
>
>Does changing your sqlca.h as above fix your problem.  If so, then I
>will submit a patch to the pgsql-ports mailing list.
>
>Are there other ESQL related symbols that need the __declspec(dllimport)
>attribute too?

I don't know.  I am just trying to learn ESQL but I'll let you know if
I come across another one.


Thanks again,
Michael