Re: Transaction end on error - Mailing list pgsql-general

From Richard Huxton
Subject Re: Transaction end on error
Date
Msg-id 200402041318.37878.dev@archonet.com
Whole thread Raw
In response to Transaction end on error  (Christian Traber <christian@traber-net.de>)
List pgsql-general
On Wednesday 04 February 2004 09:54, Christian Traber wrote:
> Hi,
>
> Postgres gives an error (ERROR:  current transaction is aborted,
> commands ignored until end of transaction block)
> on the next sql statement after an error during a transaction and the
> transaction is rolled back
> In Oracle you can go on with the transaction after an error and commit
> or rollback...
> Is there a way to change this behaviour? Somthing like a autorollback
> off;-)

I'm afraid not. Nested transactions will let you do this, and they are being
looked into - they might be in the next release, might not.

--
  Richard Huxton
  Archonet Ltd

pgsql-general by date:

Previous
From: "Rod K"
Date:
Subject: Re: BLOB problem
Next
From: Francois Suter
Date:
Subject: Re: Anyone has nls activated on Mac OS X?