ramiya

• Apr 30th, 2006

 

What is the difference between User-level, Statement-level and System-level Rollback? Can you please give me example of each?

KAILASH CHANDRA

• May 1st, 2006

 

no comments

rajanipriya

 Profile Answers by rajanipriya Questions by rajanipriya

• Jun 6th, 2006

 

please someone who knows it well , reply naaa!!!!!!!!!!

kamini

• Nov 7th, 2006

 

1. System - level or transaction level
   Rollback the current transaction entirely on errors. This was the unique
   behavior of old drivers becauase PG has no savepoint functionality until
   8.0.

2. Statement
   Rollback the current (ODBC) statement on errors (in case of 8.0 or later
   version servers). The driver calls a SAVEPOINT command just before starting
   each (ODBC) statement and automatically ROLLBACK to the savepoint on errors
   or RELEASE it on success. If you expect Oracle-like automatic per statement
   rollback, please use this level.

3. User Level
   You can(have to) call some SAVEPOINT commands and rollback to a savepoint
   on errors by yourself. Please note you have to rollback the current
   transcation or ROLLBACK to a savepoint on errors (by yourself) to continue
   the application

kameshakundy

• Nov 12th, 2006

 

Dear Kamini,

May I know what do you mean by PG

g_sidhu

 Profile 

• Feb 1st, 2008

 

Statement-level: Part of a transaction can be discarded by an implicit rollback if a statement execution error is detected. If a single DML statement fails during execution of a transaction, it s effect is undone by a statement-level rollback, but the changes made by the previous DML statements in the transaction are not discarded. They can be committed or rolled back explicitly by the user