Hi All,

I have a requirement where my application tries to enter the duplicate row in 
table using batchexceute code. And batch exception is thrown we checked error 
code and skip it but after this exception all my next update/insert gets error 
out with following 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 is set warning is generated instead 
of Exception so the other insert/update can proceed ahead.



-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Reply via email to