PGAPI_SetPos error

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



---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Re: PGAPI_SetPos error

Thu, Aug 03, 2006 at 08:57:39AM -0700, Patrick Hatcher wrote:
> ODBC v 8.1.2
>
> 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
>
> Any suggestion as to what I can do?

Hello

The psqlODBC 08.01.XXXX doesn't support updateable cursors. I know there
is such option. But it doesn't work. Please try 08.02.0002 and then
replace the dlls with once from:

http://www.geocities.jp/inocchichichi/psqlodbc/index.html

It's the latest. The version there is 07.03.XXXX but you should use it.
I don't know why Hiroshi use that numbering.

Regards,

Luf

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Re: PGAPI_SetPos error

Thanks! I'll give this a try and report back.

Patrick Hatcher
Development Manager Analytics/MIO
Macys.com




Ludek Finstrle

To
08/06/06 11:46 PM Patrick Hatcher

cc
pgsql-odbc@postgresql.org
Subject
Re: [ODBC] PGAPI_SetPos error










Thu, Aug 03, 2006 at 08:57:39AM -0700, Patrick Hatcher wrote:
> ODBC v 8.1.2
>
> 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
>
> Any suggestion as to what I can do?

Hello

The psqlODBC 08.01.XXXX doesn't support updateable cursors. I know there
is such option. But it doesn't work. Please try 08.02.0002 and then
replace the dlls with once from:

http://www.geocities.jp/inocchichichi/psqlodbc/index.html

It's the latest. The version there is 07.03.XXXX but you should use it.
I don't know why Hiroshi use that numbering.

Regards,

Luf



---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Re: PGAPI_SetPos error

That did it.
Thank you very much!

Patrick Hatcher
Development Manager Analytics/MIO
Macys.com





Patrick
Hatcher/MCOM/FDS
To
08/07/06 07:39 AM Ludek Finstrle
cc
pgsql-odbc@postgresql.org
Subject
Re: [ODBC] PGAPI_SetPos error
(Document link: Patrick Hatcher)









Thanks! I'll give this a try and report back.

Patrick Hatcher
Development Manager Analytics/MIO
Macys.com




Ludek Finstrle

To
08/06/06 11:46 PM Patrick Hatcher

cc
pgsql-odbc@postgresql.org
Subject
Re: [ODBC] PGAPI_SetPos error










Thu, Aug 03, 2006 at 08:57:39AM -0700, Patrick Hatcher wrote:
> ODBC v 8.1.2
>
> 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
>
> Any suggestion as to what I can do?

Hello

The psqlODBC 08.01.XXXX doesn't support updateable cursors. I know there
is such option. But it doesn't work. Please try 08.02.0002 and then
replace the dlls with once from:

http://www.geocities.jp/inocchichichi/psqlodbc/index.html

It's the latest. The version there is 07.03.XXXX but you should use it.
I don't know why Hiroshi use that numbering.

Regards,

Luf




---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend