Home > mailing lists

Re: failed commit question - Mailing list pgsql-novice

From	Chetan Suttraway
Subject	Re: failed commit question
Date	February 17, 2011 09:09:29
Msg-id	AANLkTimZh8sO+eb37suLd5BWZPhMy2MdiTwB2Nwtj5wF@mail.gmail.com Whole thread Raw
In response to	failed commit question (yamt@mwd.biglobe.ne.jp (YAMAMOTO Takashi))
Responses	Re: failed commit question
List	pgsql-novice

On Thu, Feb 10, 2011 at 2:22 PM, YAMAMOTO Takashi <yamt@mwd.biglobe.ne.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

From: Tom Lane
Date: 15 February 2011, 14:47:49
Subject: Re: generate_series

From: Sivakiran Balijepalli
Date: 17 February 2011, 11:07:58
Subject: regarding user creation