PGAPI_SetPos error - Mailing list pgsql-odbc

From Patrick Hatcher
Subject PGAPI_SetPos error
Date
Msg-id OF7F54418F.B85E1A33-ON882571BF.0056D96D-882571BF.0057AD33@FDS.com
Whole thread Raw
Responses Re: PGAPI_SetPos error  (Ludek Finstrle <luf@pzkagis.cz>)
List pgsql-odbc
ODBC v 8.1.2

We are using a Windows ETL program to update our Pg 8.1.x database on Linux
server.  When we try to update the table, we receive the following error:
ERROR: Error updating table entry: Only SQL_POSITION/REFRESH is supported
for PGAPI_SetPos

I have the driver parameters set as such:
Page 1 - Left column all enabled.  Nothing checked in Right column
Page 2  LF,  Updatable Cursor, Row versioning

If we are doing a straight insert, the driver performs as expected.

Any suggestion as to what I can do?

Patrick Hatcher
Development Manager  Analytics/MIO
Macys.com



pgsql-odbc by date:

Previous
From:
Date:
Subject: [ psqlodbc-Bugs-1000698 ] Crashes with Progeny
Next
From: "Rohit Prakash Khare"
Date:
Subject: Error: relation does not exist