I was trying to execute a serie of SQL requests in a transaction, by
But each BEGIN was followed by immediate COMMIT hence making
transaction impossible. As far as I get from source code, the problem
is in SC_execute (statement.c): 1010
if (!self->internal && CC_is_in_autocommit(conn) && CC_is_in_trans(conn))
res = CC_send_query(conn, "COMMIT", NULL);
(after commenting this out, I got things working).
if (strnicmp(stmt->stmt_with_params, "BEGIN;", 6) == 0)
begin_included = TRUE;
seems to be very very strange, as "BEGIN;" is not always the case
(consider "BEGIN TRANSACTION;" for instance).
Does anyone has any comments on it?
PS: I am not subscribed to this maillist, so please respond on my
e-mail as well.
Best regards, | homepage: http://www.mindon.net/illinar
Oleg Grodzevich | e-mail: illinar(at)mindon(dot)net | ICQ: 37500662
pgsql-odbc by date
|Next:||From: ozgur avci||Date: 2002-08-17 21:50:19|
|Previous:||From: Jason Koeninger||Date: 2002-08-11 00:08:13|
|Subject: Transaction Isolation Level|