Can I do anything to prevent " auto rollback in a transaction when an error occurs "

From: "junzeng" <junzeng(at)netease(dot)com>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: Can I do anything to prevent " auto rollback in a transaction when an error occurs "
Date: 2003-03-21 03:00:39
Message-ID: 000801c2ef56$0df485f0$0da8a8a8@zengjun
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

In a transaction , if a sql command invite an error , all commands before this command will be rollbacked , and the transaction reset and restart.
For example:

BEGIN
insert t1 values(1);
delete from t2
insert t1 values(2);
commit

if table t2 doesn't exist , "delete from t2" invites an error , and the insert will be rollbacked .

How can I prevent the rollback even when an error occurs ? Thanks

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Wayne Armstrong 2003-03-21 04:11:21 Re: Can I do anything to prevent " auto rollback in a transaction when an error occurs "
Previous Message pg 2003-03-21 02:03:17 Re: password leak in mylog thru win odbc