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

Поиск
Список
Период
Сортировка
Искать
От
junzeng
Тема
Can I do anything to prevent " auto rollback in a transaction when an error occurs "
Дата
Msg-id
000801c2ef56$0df485f0$0da8a8a8@zengjun
Список
Дерево обсуждения
Can I do anything to prevent " auto rollback in a transaction when an error occurs " "junzeng" <junzeng@netease.com>
Re: Can I do anything to prevent " auto rollback in a transaction when an error occurs " "Wayne Armstrong" <wdarmst@bacchus.com.au>
Re: Can I do anything to prevent " auto rollback in a transaction when an error occurs " Chris Gamache <cgg007@yahoo.com>
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
 
 
 
 
 
В списке pgsql-odbc по дате отправления
От: pg
Дата:
От: Wayne Armstrong
Дата:
FAQ