From: | Tim Nelson <TNELSON(at)ECS-INC(dot)com> |
---|---|
To: | "'pgsql-bugs(at)postgresql(dot)org'" <pgsql-bugs(at)postgresql(dot)org> |
Subject: | ecpg "aborts" on structure reference |
Date: | 2002-01-09 13:25:54 |
Message-ID: | 63BD6AB4FBBED411B3E20004ACAE8B63014455@str_nt01.ecs-inc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Think I've identified a bug in ecpg 2.8 (RH7.1) the following
code aborts (crashes) ecpg:
exec sql include sqlca;
exec sql include ../../libhome/dbincs/apc_layout.h;
exec sql include ../../libhome/dbincs/apc_layo_fld.h;
static int
get_org_name()
{
exec sql begin declare section;
APC_LAYOUT PL;
APC_LAYO_FLD PLF;
char curr_sect[2];
exec sql end declare section;
if (1) {
exec sql declare fld_curs cursor for
select apc_layo_fld.*
from apc_layo_fld
where apcl_id = :PL.apcl_id
and apclf_sect_flg = :curr_sect
order by apclf_ln_nbr, apclf_col_nbr;
}
exec sql open fld_curs;
}
... key line here is "where apcl_id = :PL.apcl_id" if I replace
it with "where apcl_id = 1" ... ecpg no longer crashes.
If this has been fixed in 2.9, I would be happy to beta it since
I am porting more that million lines of code from Informix ESQL to
Postgres. I am not sure how to get the latest version since
I am new to the open source game.
Thanks.
Tim Nelson
From | Date | Subject | |
---|---|---|---|
Next Message | pgsql-bugs | 2002-01-09 14:52:14 | Bug #558: JDBC InputStream.read() from oid returns incorrect values for negative bytes and really messes up -1 |
Previous Message | jason | 2002-01-09 06:07:43 | createlang |