| 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: | Whole Thread | Raw Message | 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 |