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
обсуждение исходный текст
Ответы Re: Can I do anything to prevent " auto rollback in a transaction when an error occurs "  ("Wayne Armstrong" <wdarmst@bacchus.com.au>)
Список 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
 
 
 
 
 

В списке pgsql-odbc по дате отправления:

Предыдущее
От: "pg"
Дата:
Сообщение: Re: password leak in mylog thru win odbc
Следующее
От: "Wayne Armstrong"
Дата:
Сообщение: Re: Can I do anything to prevent " auto rollback in a transaction when an error occurs "