Re: failed commit question

From: Chetan Suttraway <chetan(dot)suttraway(at)enterprisedb(dot)com>
To: YAMAMOTO Takashi <yamt(at)mwd(dot)biglobe(dot)ne(dot)jp>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: failed commit question
Date: 2011-02-17 10:08:47
Message-ID: AANLkTimZh8sO+eb37suLd5BWZPhMy2MdiTwB2Nwtj5wF@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Sivakiran Balijepalli 2011-02-17 11:57:17 regarding user creation
Previous Message Tom Lane 2011-02-15 15:47:35 Re: generate_series