On Thu, Feb 10, 2011 at 2:22 PM, YAMAMOTO Takashi <yamt(at)mwd(dot)biglobe(dot)ne(dot)jp>wrote:
> hi,
>
> when COMMIT failed, does it leave the transaction opened
> (thus ROLLBACK is necessary) ?
>
The transaction is marked for rollback.
check this discussion:
http://archives.postgresql.org/pgsql-jdbc/2005-01/msg00117.php
Tip: always try to dig up the archives for similar issues, before posting.
--
Chetan Sutrave
http://www.enterprisedb.com