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

From: Marcin Mirosław <marcin(at)mejor(dot)pl>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Re: Current transaction is aborted, commands ignored until end of transaction block
Date: 2011-12-30 11:07:19
Message-ID: 4EFD9B67.30308@mejor.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Thomas Kellerer 2011-12-30 11:18:09 Re: Current transaction is aborted, commands ignored until end of transaction block
Previous Message Thomas Kellerer 2011-12-30 11:03:31 Re: Current transaction is aborted, commands ignored until end of transaction block