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
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 |