Hi MIchael, I tried to fix the offset problem. PFA the patch. It does solve the problem of setting wrong offset in ECPGdo() call.
But then there is problem of interpreting the result from server as an array within array of structure. The problem is there is in ecpg_get_data(). This function can not understand that the "field" is an array of integers (or for that matter array of anything) and store all the values in contiguous memory at the given address. On Thu, Mar 27, 2014 at 11:05 PM, Michael Meskes <mes...@postgresql.org>wrote: > On Mon, Mar 24, 2014 at 11:52:30AM +0530, Ashutosh Bapat wrote: > > For all the members of struct employee, except arr_col, the size of array > > is set to 14 and next member offset is set of sizeof (struct employee). > But > > for arr_col they are set to 3 and sizeof(int) resp. So, for the next row > > onwards, the calculated offset of arr_col member would not coincide with > > the real arr_col member's address. > > > > Am I missing something here? > > No, this looks like a bug to me. I haven't had time to look into the > source codebut the offset definitely is off. > > Michael > -- > Michael Meskes > Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org) > Michael at BorussiaFan dot De, Meskes at (Debian|Postgresql) dot Org > Jabber: michael.meskes at gmail dot com > VfL Borussia! Força Barça! Go SF 49ers! Use Debian GNU/Linux, PostgreSQL > -- Best Wishes, Ashutosh Bapat EnterpriseDB Corporation The Postgres Database Company
diff --git a/src/interfaces/ecpg/preproc/type.c b/src/interfaces/ecpg/preproc/type.c index 2982cb6..53983fe 100644 --- a/src/interfaces/ecpg/preproc/type.c +++ b/src/interfaces/ecpg/preproc/type.c @@ -296,21 +296,22 @@ ECPGdump_a_type(FILE *o, const char *name, struct ECPGtype * type, const int bra type->u.element, (ind_type == NULL) ? NULL : ((ind_type->type == ECPGt_NO_INDICATOR) ? ind_type : ind_type->u.element), prefix, ind_prefix); break; default: if (!IS_SIMPLE_TYPE(type->u.element->type)) base_yyerror("internal error: unknown datatype, please report this to <pgsql-b...@postgresql.org>"); ECPGdump_a_simple(o, name, type->u.element->type, - type->u.element->size, type->size, NULL, prefix, type->u.element->counter); + type->u.element->size, type->size, struct_sizeof ? struct_sizeof : NULL, + prefix, type->u.element->counter); if (ind_type != NULL) { if (ind_type->type == ECPGt_NO_INDICATOR) { char *str_neg_one = mm_strdup("-1"); ECPGdump_a_simple(o, ind_name, ind_type->type, ind_type->size, str_neg_one, NULL, ind_prefix, 0); free(str_neg_one); } else
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers