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
Дата
Msg-id 201112301044.33861.leif@solumslekt.org
обсуждение исходный текст
Ответ на Re: Current transaction is aborted, commands ignored until end of transaction block  (Jan Bakuwel <jan.bakuwel@greenpeace.org>)
Ответы Re: Current transaction is aborted, commands ignored until end of transaction block  (Thomas Kellerer <spam_eater@gmx.net>)
Re: Current transaction is aborted, commands ignored until end of transaction block  (Jan Bakuwel <jan.bakuwel@greenpeace.org>)
Список pgsql-sql
Дерево обсуждения 
 Fredag 30. desember 2011 09.43.38 skrev Jan Bakuwel :

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

That option is called MySQL with MyISAM tables.

Seriously, if the user encounters a constraint violation, that is IMO a 
symptom of bad design. Such conditions should be checked and caught _before_ 
the transaction begins.

regards, Leif

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

Предыдущее
От: Jan Bakuwel
Дата:
Сообщение: Re: Current transaction is aborted, commands ignored until end of transaction block
Следующее
От: Thomas Kellerer
Дата:
Сообщение: Re: Current transaction is aborted, commands ignored until end of transaction block