Avoid transaction abot if/when constraint violated

Поиск
Список
Период
Сортировка

Hello !

 

I have a long list of records I want to insert into a table in such a way as I can trap and report any/all constraint violations before rolling back (or opting to commit).  Unfortunately, after I hit the first constraint violation, it aborts the transaction, and then reports “ERROR: current transaction is aborted, commands ignored until end of transaction block”.

 

Is there a way around this?

 

Thanks in Advance!

В списке pgsql-general по дате отправления: