handling duplicate row exception
От | Amar Dhole |
---|---|
Тема | handling duplicate row exception |
Дата | |
Msg-id | B056671652AA4D418763981054BCEAB408F1BF@PA-MBX04.na.tibco.com обсуждение исходный текст |
Ответ на | Re: Combining several CTEs with a recursive CTE (Thomas Kellerer <spam_eater@gmx.net>) |
Ответы |
Re: handling duplicate row exception
|
Список | pgsql-sql |
Hi All, I have a requirement where my application tries to enter the duplicate row in table using batchexceute code. And batch exceptionis thrown we checked error code and skip it but after this exception all my next update/insert gets error out withfollowing exception "Database error. SQL state 25P02. Database specific error code (if any) was 0. Database error message (if any) was: org.postgresql.util.PSQLException:ERROR: current transaction is aborted, commands ignored until end of transaction block.: Is there any way to proceed ahead like in sql server we have options while creating table IGNORE_DUP_KEY = ON if this isset warning is generated instead of Exception so the other insert/update can proceed ahead.
В списке pgsql-sql по дате отправления: