select from a table having more than 32 fields: Quick Workaround - Mailing list pgsql-odbc

From Matteo Cavalleri
Subject select from a table having more than 32 fields: Quick Workaround
Date
Msg-id 3A93F1AC.22574.8EB290@localhost
Whole thread Raw
Responses Re: select from a table having more than 32 fields: Quick Workaround  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-odbc
Description:
A select from a table having more than 32 fields fails during
SQLDescribeCol on field # 33.

Test:
create a 52 fields table. Insert 1 record. select * from table name.
The error comes out.
I get the error on a table with 52 field using psqlodbc version
6.50.000, Borland C++Builder or Centura.

What's going on?
In my opinion the driver try to allocate space for fields in blocks of
32 items as defined in FLD_INCR (parse.c) . The realloc() works
well but for some reasons the fi pointer seems to get lost during
SQLDescribeCol on column 1.

Quick workaround:
increase FLD_INCR, from 32 to how you need.
Byron will help better....

pgsql-odbc by date:

Previous
From: Cedar Cox
Date:
Subject: Re: ODBC Driver regedit file.
Next
From: Tom Lane
Date:
Subject: Re: select from a table having more than 32 fields: Quick Workaround