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

Oops, I forgot to mention that hopefully the driver handles inheritance.

regards,
Hiroshi Inoue

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@dream.email.ne.jp]
Sent: Tuesday, May 17, 2016 6:09 PM
To: Venkatesan, Sekhar; Tsunakawa, Takayuki
Cc: Adrian Klaver; Joshua D. Drake; pgsql-odbc@postgresql.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.takay@jp.fujitsu.com]
Sent: Wednesday, May 11, 2016 1:26 PM
To: Venkatesan, Sekhar; Inoue, Hiroshi
Cc: Adrian Klaver; Joshua D. Drake; pgsql-odbc@postgresql.org
Subject: RE: [ODBC] PostgreSQL: SQLSetPos fails with SetPos update return error.

 

From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.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