Re: ECPG Segfaulting on EXEC SQL connect

On Tue, Dec 28, 2004 at 10:16:04PM -0000, John Smith wrote:
> I'm trying to convert a series of C programs written originally using
> Informix ESQL to use Postgres' ECPG.
> ...
> 575 EXEC SQL connect to pdev_changename;
> ...
> 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.

Could you please try rc3? I did fix some segfaults in the connect
statement. However, I'm not sure you hit the same bug,
actually I expect it to be a different one.

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

You can use the datatypes without informix mode. You just have to
include the pgtypes_*.h header files yourself.

> Can anyone help shed any light on this?

I will try if you could send me an example to reproduce the problem. As
you said it does not happen on a small self written test case. Maybe you
can send me one of your source files stripped down to just connect.

Michael
--
Michael Meskes
Email: Michael at Fam-Meskes dot De
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes(at)jabber(dot)org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!