Quick Links

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

From:	Leif Biberg Kristensen <leif(at)solumslekt(dot)org>
To:	pgsql-sql(at)postgresql(dot)org
Subject:	Re: Current transaction is aborted, commands ignored until end of transaction block
Date:	2011-12-30 09:44:33
Message-ID:	201112301044.33861.leif@solumslekt.org
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-sql

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

In response to

Re: Current transaction is aborted, commands ignored until end of transaction block at 2011-12-30 08:43:38 from Jan Bakuwel

Responses

Re: Current transaction is aborted, commands ignored until end of transaction block at 2011-12-30 11:03:31 from Thomas Kellerer
Re: Current transaction is aborted, commands ignored until end of transaction block at 2011-12-30 22:51:41 from Jan Bakuwel

Browse pgsql-sql by date

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