Skip site navigation (1) Skip section navigation (2)

RE: how to continue a transaction after an error?

From: "Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)COM>
To: "'Cristi Petrescu-Prahova'" <cristipp(at)lasting(dot)ro>, pgsql-sql(at)postgresql(dot)org
Subject: RE: how to continue a transaction after an error?
Date: 2000-11-15 19:11:27
Message-ID: 8F4C99C66D04D4118F580090272A7A234D3181@sectorbase1.sectorbase.com (view raw or flat)
Thread:
Lists: 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

Next:From: Peter EisentrautDate: 2000-11-15 22:33:18
Subject: Re: Index problem
Previous:From: Tom LaneDate: 2000-11-15 18:19:45
Subject: Re: Index problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group