Re: [SQL] how to continue a transaction after an error?

2000-11-13 Thread Cristi Petrescu-Prahova
Multiple transactions carry a price: one cannot isolate the insertions from other sessions. This is not desirable in my case. The second suggestion is valuable. Thanks, Cristi - Original Message - From: Edmar Wiggers <[EMAIL PROTECTED]> To: Cristi Petrescu-Prahova <[EMAIL

[SQL] how to continue a transaction after an error?

2000-11-13 Thread Cristi Petrescu-Prahova
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