Postgres Pro
Downloads
Home   >   mailing lists

Re: Current transaction is aborted, commands ignored until end of transaction block - Mailing list pgsql-sql

From Leif Biberg Kristensen
Subject Re: Current transaction is aborted, commands ignored until end of transaction block
Date
Msg-id 201112301044.33861.leif@solumslekt.org
Whole thread Raw
In response to Re: Current transaction is aborted, commands ignored until end of transaction block  (Jan Bakuwel <jan.bakuwel@greenpeace.org>)
Responses Re: Current transaction is aborted, commands ignored until end of transaction block
Re: Current transaction is aborted, commands ignored until end of transaction block
List pgsql-sql
Tree view 
 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 by date:

Previous
From: Jan Bakuwel
Date:
Subject: Re: Current transaction is aborted, commands ignored until end of transaction block
Next
From: Thomas Kellerer
Date:
Subject: Re: Current transaction is aborted, commands ignored until end of transaction block