| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Christian Traber <christian(at)traber-net(dot)de>, Pgsql-General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Transaction end on error |
| Date: | 2004-02-04 13:18:37 |
| Message-ID: | 200402041318.37878.dev@archonet.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Francois Suter | 2004-02-04 13:38:47 | Re: Anyone has nls activated on Mac OS X? |
| Previous Message | Rod K | 2004-02-04 11:58:03 | Re: BLOB problem |