Skip site navigation (1) Skip section navigation (2)

Re: Postgres 7.1RC4 ecpg can't find sqlca

From: Jason Tishler <Jason(dot)Tishler(at)dothill(dot)com>
To: Michael Lemke <lemkemch(at)t-online(dot)de>
Cc: cygwin(at)cygwin(dot)com, Pgsql-Ports <pgsql-ports(at)postgresql(dot)org>
Subject: Re: Postgres 7.1RC4 ecpg can't find sqlca
Date: 2001-04-13 22:08:14
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-ports

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;
    extern struct sqlca sqlca;

or by

#ifdef __CYGWIN__
    extern DLLIMPORT struct sqlca sqlca;
    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?


Jason Tishler
Director, Software Engineering       Phone: +1 (732) 264-8770 x235
Dot Hill Systems Corp.               Fax:   +1 (732) 264-8798
82 Bethany Road, Suite 7             Email: Jason(dot)Tishler(at)dothill(dot)com
Hazlet, NJ 07730 USA                 WWW:

pgsql-ports by date

Next:From: Peter EisentrautDate: 2001-04-14 01:33:40
Subject: Re: compile error with postgresql-7.1rc4
Previous:From: Rocco AltierDate: 2001-04-13 18:22:37
Subject: Re: AIX 4.1 shared library support

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group