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
Дата	30 декабря 2011 г. 05:44:50
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 Re: Current transaction is aborted, commands ignored until end of transaction block
Список	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 по дате отправления:

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

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