Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229])
	by mail.postgresql.org (Postfix) with ESMTP id DEACAC24692
	for <pgsql-sql@postgresql.org>; Fri, 30 Dec 2011 05:44:48 -0400 (AST)
Received: from mail44.e.nsc.no ([193.213.115.44])
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <leif@solumslekt.org>) id 1RgZ15-0007RQ-3d
	for pgsql-sql@postgresql.org; Fri, 30 Dec 2011 09:44:48 +0000
Received: from balapapa.localnet (81.61.9.46.customer.cdi.no [46.9.61.81])
	(authenticated bits=0)
	by mail44.nsc.no (8.14.4/8.14.4) with ESMTP id pBU9iYD8019758
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NOT)
	for <pgsql-sql@postgresql.org>; Fri, 30 Dec 2011 10:44:34 +0100 (MET)
From: Leif Biberg Kristensen <leif@solumslekt.org>
To: pgsql-sql@postgresql.org
Subject: Re: Current transaction is aborted,
	commands ignored until end of transaction block
Date: Fri, 30 Dec 2011 10:44:33 +0100
User-Agent: KMail/1.13.7 (Linux/3.0.6-gentoo; KDE/4.7.3; x86_64; ; )
References: <4EFD3D32.9060902@greenpeace.org>
	<13131805-BCBB-42DF-953B-27EE36AAF213@yahoo.com>
	<4EFD79BA.50508@greenpeace.org>
In-Reply-To: <4EFD79BA.50508@greenpeace.org>
MIME-Version: 1.0
Content-Type: Text/Plain;
  charset="iso-8859-15"
Content-Transfer-Encoding: 7bit
Message-Id: <201112301044.33861.leif@solumslekt.org>
X-Pg-Spam-Score: -1.9 (-)
X-Archive-Number: 201112/92
X-Sequence-Number: 36153

 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