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?
pgsql-sql by date
|Next:||From: Stephan Szabo||Date: 2000-11-13 19:57:48|
|Subject: Re: how to continue a transaction after an error?|
|Previous:||From: Steve Wampler||Date: 2000-11-13 19:36:35|
|Subject: Re: Using a postgres table to maintain unique id?|