Postgres Pro
Downloads
Home   >   mailing lists

ODBC Driver Error - prepared statement broken after execution error - Mailing list pgsql-odbc

From Vladimir Romanov
Subject ODBC Driver Error - prepared statement broken after execution error
Date
Msg-id CAJ4CROjqeFDh=8gARCvLPfKoVBcxW2-sj3YFC1u3qy0NY2_XBw@mail.gmail.com
Whole thread Raw
Responses Re: ODBC Driver Error - prepared statement broken after execution error  ("Inoue, Hiroshi" <inoue@tpf.co.jp>)
List pgsql-odbc
Tree view
Hello!

I found some problem in ODBC Driver. How to reproduce
1) Prepare statement
2) Do some calls to get for sample "duplicate primary key error"
3) After this every call o this statement return error.
4) Other statements can be executed w/o problems

db_insert(1,1); //ok
db_insert(1,2); //error
db_insert(2,3); //error
db_select(2,&value); //ok

Error log:
Retcode [-1] when executing SQLExecute(stmt_insert)
Error [-1] in SQLExecute(stmt_insert)ERROR:
[unixODBC]ERROR: duplicate key value violates unique constraint "bench_pk"
Key (id)=(1) already exists.;
Error while executing the query
ODBC Error/Warning = 23505, Additional Error/Warning = 7

Retcode [-1] when executing SQLExecute(stmt_insert)
Error [-1] in SQLExecute(stmt_insert)ERROR:
[unixODBC]Error while executing the query
ODBC Error/Warning = S1000, Additional Error/Warning = 7


--
Vladimir Romanov

pgsql-odbc by date:

Previous
From: Vladimir Romanov
Date:
Subject: ODBC Driver performance comparison
Next
From: Heikki Linnakangas
Date:
Subject: Re: ODBC Driver performance comparison