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

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Current transaction is aborted, commands ignored until end of transaction block
Date: 2011-12-30 11:03:31
Message-ID: jdk5q0$kho$1@dough.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Marcin Mirosław 2011-12-30 11:07:19 Re: Re: Current transaction is aborted, commands ignored until end of transaction block
Previous Message Leif Biberg Kristensen 2011-12-30 09:44:33 Re: Current transaction is aborted, commands ignored until end of transaction block