Re: VS: VS: Prepared statement error with UseServerSidePrepare=1

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: lev(dot)bukovski(at)teliasonera(dot)com
Cc: pgsql-odbc <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: VS: VS: Prepared statement error with UseServerSidePrepare=1
Date: 2014-06-01 20:10:55
Message-ID: 538B88CF.5020807@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

On 06/01/2014 12:19 PM, lev(dot)bukovski(at)teliasonera(dot)com wrote:
> Rollback is successfull, no problems on that.
>
> Log files in the original message have exact error code and description,
> but like I wrote
>
> on wrong insert I get logical error "duplicate key value violates unique
> constraint "key11_disp_idx". Error while executing the query", but when
> I afterward try to make correct insert, I still get an error from
> psqlodbc "Error while executing the query", which is like a last part of
> the first error.
>

Hmm, not sure what is going on.

I would say you will need to show the full code of what you are doing in
the Prepare/bind/Execute cycle. Hopefully others can see if there is
anything out of place. Would not hurt to crank the psqlodbc logging and
capture that also.

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

Browse pgsql-odbc by date

  From Date Subject
Next Message Adrian Klaver 2014-06-01 20:53:44 Re: 126 Error Connecting With psqlODBC 32 bit
Previous Message John Smith 2014-05-30 19:04:30 Re: Problems using SQLFetch on prepared INSERT with RETURNING clause