Re: Current transaction is aborted, commands ignored until end of transaction block

Поиск
Список
Период
Сортировка
От Jan Bakuwel
Тема Re: Current transaction is aborted, commands ignored until end of transaction block
Дата
Msg-id 4EFD79BA.50508@greenpeace.org
обсуждение исходный текст
Ответ на Re: Current transaction is aborted, commands ignored until end of transaction block  (David Johnston <polobo@yahoo.com>)
Ответы Re: Current transaction is aborted, commands ignored until end of transaction block  (Leif Biberg Kristensen <leif@solumslekt.org>)
Список pgsql-sql
Дерево обсуждения 
Hi David,


> Start a "savepoint" before each sub-update and rollback to the savepoint if the update fails, and then try again with
differentdata.  If it succeeds you then release the savepoint anad move on. 

Yeah... not ideal in my case & will result in "messy" code...

Would be nice to have an option in PostgreSQL something along the lines
of:  'abort-transaction-on-constraint-violation = false'....

Jan

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

Предыдущее
От: David Johnston
Дата:
Сообщение: Re: Current transaction is aborted, commands ignored until end of transaction block
Следующее
От: Leif Biberg Kristensen
Дата:
Сообщение: Re: Current transaction is aborted, commands ignored until end of transaction block