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

Поиск
Список
Период
Сортировка
От Marcin Mirosław
Тема Re: Re: Current transaction is aborted, commands ignored until end of transaction block
Дата
Msg-id 4EFD9B67.30308@mejor.pl
обсуждение исходный текст
Ответ на 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  (Thomas Kellerer <spam_eater@gmx.net>)
Список pgsql-sql
W dniu 30.12.2011 12:03, Thomas Kellerer pisze:
> Leif Biberg Kristensen wrote on 30.12.2011 10:44:
>>   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.
>>
> Not true.
> 
> Oracle and others (I believe at least DB2) behave such that you can
> insert a bunch of rows and if one or more throw a constraint violation,
> the transaction can still be committed persisting those that do not
> violate the constraint.

Hi,
isn't this option:
http://www.postgresql.org/docs/current/static/sql-set-constraints.html ?
Regards


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

Предыдущее
От: Thomas Kellerer
Дата:
Сообщение: 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