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

Hi,

OK we would make a new release.
I have to apply several patches before the release.

regards,
Hiroshi Inoue

On 2016/06/14 17:33, Venkatesan, Sekhar wrote:
>
> Hi Inoue/Takayuki,
>
> Just need information on the new fix for child table inheritance. How
> can I get a new build with this change?
>
> Please help me with an answer.
>
> Thanks,
>
> Sekhar
>
> *From:*Venkatesan, Sekhar
> *Sent:* Tuesday, June 07, 2016 9:34 AM
> *To:* 'Inoue, Hiroshi'
> *Cc:* Tsunakawa, Takayuki; Adrian Klaver; Joshua D. Drake;
> pgsql-odbc(at)postgresql(dot)org
> *Subject:* RE: [ODBC] PostgreSQL: SQLSetPos fails with SetPos update
> return error.
>
> Hi Inoue,
>
> When can I expect a build for windows and linux? This is required to
> do complete functional testing on our side.
>
> Will it be updated in
> https://www.postgresql.org/ftp/odbc/versions/msi/
> <https://www.postgresql.org/ftp/odbc/versions/msi/> ?
>
> Thanks,
>
> Sekhar
>
> *From:*Inoue, Hiroshi [mailto:h-inoue(at)dream(dot)email(dot)ne(dot)jp]
> *Sent:* Friday, May 27, 2016 4:56 PM
> *To:* Venkatesan, Sekhar
> *Cc:* Tsunakawa, Takayuki; 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.
>
> I just pushed the change about inheritance to git.
>
> regards,
> Hiroshi Inoue
>
> On 2016/05/25 15:02, Venkatesan, Sekhar wrote:
>
> Inoue,
>
> Can you please let me know if a fix can be provided for the
> “SetPos Update” issue. I need it for Linux and Windows?
>
> Thanks,
> Sekhar
>
> *From:*Venkatesan, Sekhar
> *Sent:* Wednesday, May 25, 2016 11:04 AM
> *To:* 'Tsunakawa, Takayuki'
> *Cc:* Inoue, Hiroshi; 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.
>
> Hi Takayuki/ Inoue,
>
> When partition is enabled in my application and I change the
> partitioning key in the table to save the new data into another
> partition, I get error like this:
>
> ERROR: new row for relation "testpart_s" violates check constraint
> " p1_testpart12_s"
>
> *I enabled **constraint_exclusion in postgresql.conf.*
>
> I followed the document you shared to enable row movement across
> partitions by writing triggers on partition tables. It works up to
> a point but not confident it will work for all use-cases.
>
> If this can be fixed in the odbc driver itself, it would be
> better. Let me know your thoughts on this.
>
> Thanks,
> Sekhar
>
> *From:*Tsunakawa, Takayuki [mailto:tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com]
> *Sent:* Monday, May 23, 2016 1:18 PM
> *To:* Venkatesan, Sekhar
> *Cc:* Inoue, Hiroshi; 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
>
> The latest driver provided resolves the “SetPos update” error that
> you guys mentioned. Thanks for the fix.
>
> That's good news.
>
> Is the fix provided an official and certified one? Can you also
> provide the fix for Linux?
>
> Inoue-san is the only committer now and he will decide that.
>
> There is one another issue regarding partition’s automatic row
> movement with regards to partitioning key change. This is not fixed.
>
> Let me know if it is feasible to fix that as well.
>
> As Inoue-san and I mentioned before, automatic row movement seems
> to have nothing to do with your problem. Could you elaborate your
> test case which fails?
>
> Regards
>
> Takayuki Tsunakawa
>