PostgreSQL: SQLSetPos fails with SetPos update return error.

From: "Venkatesan, Sekhar" <sekhar(dot)venkatesan(at)emc(dot)com>
To: "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject: PostgreSQL: SQLSetPos fails with SetPos update return error.
Date: 2016-04-19 06:53:51
Message-ID: F84DE43FDACD4C45AA84E2DA016FAE2F1C6A66C1@MX105CL01.corp.emc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi Guys,

I am hitting a peculiar error when trying to update a row in PostgreSQL database using odbc SQLSetPos call.
I read in PostgreSQL forums that it doesn't support POSITIONED UPDATE.

The error being returned is:

STATE=HY000, CODE=7, MSG=SetPos update return error\n" ...} }

I am using 09.03.04 version of postgres ODBC driver and 9.4.5 version of postgres server.
IS there any known issue when doing update using odbc SQLSetPos API?
Any workaround/solution that can be applied to get rid of this problem?
This needs to be resolved as soon as possible. So any feedback would be really helpful.

Thanks,
Sekhar

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Inoue, Hiroshi 2016-04-19 09:41:16 Re: PostgreSQL: SQLSetPos fails with SetPos update return error.
Previous Message Pavel Raiskup 2016-04-19 05:20:29 Re: psqlODBC 09.05.0200 Released