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: (view raw or whole 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:

Tip: always try to dig up the archives for similar issues, before posting.

Chetan Sutrave

In response to


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-2015 The PostgreSQL Global Development Group