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

From Cristi Petrescu-Prahova
Subject how to continue a transaction after an error?
Date
Msg-id 002e01c04da9$a8f95c20$25efe6c1@lasting.ro
Whole thread Raw
Responses Re: how to continue a transaction after an error?
Re: how to continue a transaction after an error?
RE: how to continue a transaction after an error?
List pgsql-sql
Hello,

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?

Thanks,
Cristi



pgsql-sql by date:

Previous
From: Steve Wampler
Date:
Subject: Re: Using a postgres table to maintain unique id?
Next
From: Stephan Szabo
Date:
Subject: Re: how to continue a transaction after an error?