Problem in doing bulk inserts thru ODBC API calls - Mailing list pgsql-patches

From Harish Agarwal
Subject Problem in doing bulk inserts thru ODBC API calls
Date
Msg-id 200103210014.AA6095184@convexant.com
Whole thread Raw
List pgsql-patches
Hello,
I am facing a problem with the SQLBulkOperations call with argument SQL_ADD. Though the SQL_ODBC_VER and
DRIVER_ODBC_VER,(reflected by SQLGetInfo) is 3.51 and 06.40.0007 respectively. 

The return code for the call
SQLBulkOperations(h_stmt, SQL_ADD) is -1 and the error returned is [unixODBC]Only SQL_POSITION/REFRESH is supported for
SQLSetPos,SQLSTATE=HYC00. 

How do I verify that the driver supports (or not) a call to SQLBulkOperations with SQL_ADD.

Is there some other way of getting bulk inserts done. The ODBC driver being used is one provided by PostODBC for
PostGres.

regards & thanks,
Harish

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Patch application
Next
From: Roberto Mello
Date:
Subject: Re: [HACKERS] Patch application