Re: PostgreSQL: SQLSetPos fails with SetPos update return error.

I don't think the cause of the SQLSetPos failure reported is partition
row movement.

regards,
Hiroshi Inoue

On 2016/05/18 2:53, Venkatesan, Sekhar wrote:
>
> Does this new odbc driver addresses automatic row movement during
> partition key changes?
>
> *From:*Inoue, Hiroshi [mailto:h-inoue(at)dream(dot)email(dot)ne(dot)jp]
> *Sent:* Tuesday, May 17, 2016 6:09 PM
> *To:* Venkatesan, Sekhar; Tsunakawa, Takayuki
> *Cc:* Adrian Klaver; Joshua D. Drake; pgsql-odbc(at)postgresql(dot)org
> *Subject:* Re: [ODBC] PostgreSQL: SQLSetPos fails with SetPos update
> return error.
>
> Hi,
>
> Could you please try the 09.05.0211 at
> http://www.ne.jp/asahi/inocchichichi/entrance/psqlodbc/index.html
> ?
>
> regards,
> Hiroshi Inoue
>
> On 2016/05/17 13:39, Venkatesan, Sekhar wrote:
>
> Thanks Takayuki. Let me know your plans/progress as and when you
> have more information on this.
>
> Thanks,
>
> Sekhar
>
> *From:*Tsunakawa, Takayuki [mailto:tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com]
> *Sent:* Wednesday, May 11, 2016 1:26 PM
> *To:* Venkatesan, Sekhar; Inoue, Hiroshi
> *Cc:* Adrian Klaver; Joshua D. Drake; pgsql-odbc(at)postgresql(dot)org
> <mailto:pgsql-odbc(at)postgresql(dot)org>
> *Subject:* RE: [ODBC] PostgreSQL: SQLSetPos fails with SetPos
> update return error.
>
> From: pgsql-odbc-owner(at)postgresql(dot)org
> <mailto:pgsql-odbc-owner(at)postgresql(dot)org>
> [mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Venkatesan,
> Sekhar
>
> Is there any plans to implement Automatic row movement for
> partition in PostgreSQL?
>
> We need to certify PostgreSQL data partitioning feature with our
> product. This is a must-do feature.
>
> We feel if the odbc driver itself supports this functionality it’s
> less cumbersome for the application.
>
> Let me know what is your plan/suggestion.
>
> I'll try to figure out if it's feasible, because I'd be glat if
> EMC certifies PostgreSQL with their products. Give me a few days.
>
> Regards
>
> Takayuki Tsunakawa
>
>