Antony Paul wrote:
> Hi all,
> What happens to transaction when an SQL exception is thrown while it is
> in a transaction. Does the connection automatically rollbacks the
> transactions or we have to roll back it ?
You have to roll it back yourself.
PostgreSQL will generate errors on subsequent queries in a transaction
after an error (until you roll it back), but that's not necessarily true
of other DBs.
-O