Re: Prepared statement error with UseServerSidePrepare=1 - Mailing list pgsql-odbc

From Adrian Klaver
Subject Re: Prepared statement error with UseServerSidePrepare=1
Date
Msg-id 5386608B.4070209@aklaver.com
Whole thread Raw
In response to Prepared statement error with UseServerSidePrepare=1  (<lev.bukovski@teliasonera.com>)
List pgsql-odbc
On 05/28/2014 01:52 AM, lev.bukovski@teliasonera.com wrote:
> Hi,
>
> I found some strangeness in psqlodbc’s behavior. May be you can explain
> to me, do I do something wrong or there is a bug.
>
> Tested on psqlodbc 9.3.3 and postgresql 9.3.4.

> I noticed the behavior on psqlodbc 9.2.1. In that version third insert
> returned same error, but didn’t really insert the data.
>
> If I disable UseServerSidePrepare=0, then third insert executes
> successfully.

I would tail the Postgres log and see what it says when you go through
the sequence. My suspicion is that it is a transaction rollback not
being handled.

>
> Thanks in advance,
>
> Lev Bukovski
>
>
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-odbc by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Doubt about ODBC Driver
Next
From: Christoph Berg
Date:
Subject: "deprecated" test needs alternative output file