ECPG Segfaulting on EXEC SQL connect

From: "John Smith" <john(at)roundel(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: ECPG Segfaulting on EXEC SQL connect
Date: 2004-12-28 22:16:04
Message-ID: 200412282214.iBSME3G8013073@romana.roundel.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I'm trying to convert a series of C programs written originally using
Informix ESQL to use Postgres' ECPG.

All of my test programs written from scratch seem to work ok, and I can now
precompile, compile and link without error, but when I actually run the
program, I get a segfault. This appears to be in the code called by EXEC SQL
CONNECT... as evidenced below (output from gdb):

Program received signal SIGSEGV, Segmentation fault.
0x08053640 in error_message ()
(gdb) up
#1 0x4005b95a in _init () from /usr/lib/libpq.so.3
(gdb) up
#2 0x4005ba8f in _init () from /usr/lib/libpq.so.3
(gdb) up
#3 0x4005c35d in fe_getauthname () from /usr/lib/libpq.so.3
(gdb) up
#4 0x4005ed2d in pqPacketSend () from /usr/lib/libpq.so.3
(gdb) up
#5 0x4005c44c in PQconnectStart () from /usr/lib/libpq.so.3
(gdb) up
#6 0x4005c90a in PQsetdbLogin () from /usr/lib/libpq.so.3
(gdb) up
#7 0x4003bf7f in ECPGconnect () from /usr/lib/libecpg.so.4
(gdb) up
#8 0x0804ed15 in cgiMain () at register_customer.pgc:575
575 EXEC SQL connect to pdev_changename;
(gdb)

The database is called pdev_changename, and that same connect statement has
worked in another test program.

I'm precompiling using
ecpg -t -C INFORMIX register_customer.pgc -o register_customer.c

and compling with
gcc -g register_customer.c <<some .o and .a files>> -o
register_customer.cgi \
-I/usr/include/pgsql -I/usr/include/pgsql/informix -lecpg -lecpg_compat
-L/usr/lib/pgsql

I'm using Postgres 8.0.0rc1 on Redhat 9 (kernel 2.4.20-31.9). The same thing
happens on fedora core 3, and using Postgres 7.4.6-1.FC3-1.

The ability to define variables of type "timestamp" etc. is so useful, so I
really want to keep using "-C INFORMIX" if I can.

Can anyone help shed any light on this?

Thanks,

John
john(at)roundel(dot)net

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mike Rylander 2004-12-28 22:34:57 Re: pgsql question
Previous Message Scott Ribe 2004-12-28 21:34:34 Re: OSX 10.3.7 broke Postgresql 8.0.0b5?