Avoid transaction abot if/when constraint violated
От | Gauthier, Dave |
---|---|
Тема | Avoid transaction abot if/when constraint violated |
Дата | |
Msg-id | 482E80323A35A54498B8B70FF2B87980043AA6BBF0@azsmsx504.amr.corp.intel.com обсуждение исходный текст |
Ответы |
Re: Avoid transaction abot if/when constraint violated
Re: Avoid transaction abot if/when constraint violated Re: Avoid transaction abot if/when constraint violated Re: Avoid transaction abot if/when constraint violated Re: Avoid transaction abot if/when constraint violated |
Список | pgsql-general |
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 по дате отправления: