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