| From: | "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com> |
|---|---|
| To: | "Venkatesan, Sekhar" <sekhar(dot)venkatesan(at)emc(dot)com>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org> |
| Subject: | Re: PostgreSQL: Autocommit through windows odbc driver doesnt work!!! |
| Date: | 2016-02-17 03:44:13 |
| Message-ID: | 0A3221C70F24FB45833433255569204D1F521579@G01JPEXMBYT05 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
Sorry, the attached test program is the right one.
Try adding the following line in postgresql.conf and run your program:
log_statement = 'all'
If SQL_AUTOCOMMIT_OFF is effective, these lines are output in the server log. This shows that the ODBC driver sent BEGIN at the first SQL statement in a transaction, and the application explicitly committed the transaction with SQLEndTran(SQL_COMMIT).
LOG: statement: BEGIN;INSERT INTO a VALUES(100)
LOG: statement: COMMIT
If SQL_AUTOCOMMIT_ON is effective, this line is output. The ODBC driver doesn't send BEGIN.
LOG: statement: INSERT INTO a VALUES(100)
Regards
Takayuki Tsunakawa
| Attachment | Content-Type | Size |
|---|---|---|
| test.c | text/plain | 1.7 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2016-02-17 15:26:27 | Re: Issue with Money field using ODBC to Access database |
| Previous Message | Tsunakawa, Takayuki | 2016-02-17 03:01:03 | Re: PostgreSQL: Autocommit through windows odbc driver doesnt work!!! |