Hello,
I'm using PostgreSQL 8.0 and Java in NetBeans IDE. In java I have a method
that does a "insert into" and it throws a "duplicate key violates unique
constraint." I call that method once and then call another method which does a
"select." However, when the select method gets called postgres throws a
"current transaction is aborted, commands ignored until end of transaction
block." I've read some of the mailing list and it says if I set
on_error_rollback to on it'll work; but when I use sql(from netbeans) to set
it, it doesn't recognize on_error_rollback. My statement is as follows:
set on_error_rollback = on
Does version 8.0 not have on_error_rollback? Is there another way of handling
this. Any help is much appreciated.
vyang
