On Mon, 13 Nov 2000, Cristi Petrescu-Prahova wrote:
> I would like to insert a bunch of rows in a table in a transaction. Some of
> the insertions will fail due to constraints violation. When this happens,
> Postgres automatically ends the transaction and rolls back all the previous
> inserts. I would like to continue the transaction and issue the
> commit/rollback command myself.
> How to do it?
> Is there any setting I am missing?
> Is it possible at all?
Currently, postgres treats all errors as critical ones that require a
complete rollback of transaction (although I believe it does not
immediately do the rollback, it should go into abort state). There's been
on and off talk about changing this, but nothing really has been decided i
In response to
pgsql-sql by date
|Next:||From: Ross J. Reedstrom||Date: 2000-11-13 20:08:08|
|Subject: Re: how to continue a transaction after an error?|
|Previous:||From: Cristi Petrescu-Prahova||Date: 2000-11-13 19:41:04|
|Subject: how to continue a transaction after an error?|