Postgres Pro
Downloads
Home   >   mailing lists

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

From Jan Bakuwel
Subject Re: Current transaction is aborted, commands ignored until end of transaction block
Date
Msg-id 4EFD79BA.50508@greenpeace.org
Whole thread Raw
In response to Re: Current transaction is aborted, commands ignored until end of transaction block  (David Johnston <polobo@yahoo.com>)
Responses Re: Current transaction is aborted, commands ignored until end of transaction block
List pgsql-sql
Tree view 
Hi David,


> Start a "savepoint" before each sub-update and rollback to the savepoint if the update fails, and then try again with
differentdata.  If it succeeds you then release the savepoint anad move on. 

Yeah... not ideal in my case & will result in "messy" code...

Would be nice to have an option in PostgreSQL something along the lines
of:  'abort-transaction-on-constraint-violation = false'....

Jan

pgsql-sql by date:

Previous
From: David Johnston
Date:
Subject: Re: Current transaction is aborted, commands ignored until end of transaction block
Next
From: Leif Biberg Kristensen
Date:
Subject: Re: Current transaction is aborted, commands ignored until end of transaction block