Meaning of Level of rollback on errors

From: "Renato Gondim" <Renato(dot)Gondim(at)SoftwareExpress(dot)com(dot)br>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: Meaning of Level of rollback on errors
Date: 2006-05-31 20:39:18
Message-ID: 001001c684f2$4a37a2b0$3c35a8c0@MRENATO
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi folks,

I've just faced a situation here at work. Our application runs on Oracle,
SqlServer, Sybase and PostGreSql. The problem was when a primary key
violation occurs: after the error, the application tries to find the
register, but if the ODBC is configured as "Transaction" on "Level of
rollback on errors", nothing is returned from the select. After a research,
I found out that I must use "Statement" , but I'd like to know what happen
when this configuration is set, because the application must start / finish
the transaction. I'm tried "Nop: don't rollback anything", cause make more
sense for me: don't do anything, let the application control the
transactions, but using it, the application can't continue and make more
statements.

Because I don't like to use something that I don't know, please, does
anybody have more information about the configurations of "Level of rollback
on errors"?

Thanks,

Renato.

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Inoue 2006-06-01 00:09:02 Re: Meaning of Level of rollback on errors
Previous Message raja chidambaram 2006-05-31 10:46:08 BUG #2460: bug on postgres crash recovery