Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

Next:From: Sivakiran BalijepalliDate: 2011-02-17 11:57:17
Subject: regarding user creation
Previous:From: Tom LaneDate: 2011-02-15 15:47:35
Subject: Re: generate_series

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group