Re: Prepared statement error with UseServerSidePrepare=1

On 05/28/2014 01:52 AM, lev(dot)bukovski(at)teliasonera(dot)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(dot)klaver(at)aklaver(dot)com