RE: how to continue a transaction after an error? - Mailing list pgsql-sql

From Mikheev, Vadim
Subject RE: how to continue a transaction after an error?
Date
Msg-id 8F4C99C66D04D4118F580090272A7A234D3181@sectorbase1.sectorbase.com
Whole thread Raw
In response to how to continue a transaction after an error?  ("Cristi Petrescu-Prahova" <cristipp@lasting.ro>)
List pgsql-sql
> 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?

Hopefully, we'll have savepoints in 7.2

Vadim


pgsql-sql by date:

Previous
From: Clayton Cottingham
Date:
Subject: Re: MySQL -> Postgres dump converter
Next
From: M.Feldtmann@t-online.de (Marten Feldtmann)
Date:
Subject: Re: Using a postgres table to maintain unique id?