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

Re: PGAdmin Auto-commits?

From: "Dave Page" <dpage(at)pgadmin(dot)org>
To: "Ryan Daniels" <ryan(dot)daniels(at)gmail(dot)com>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: PGAdmin Auto-commits?
Date: 2008-10-02 13:04:34
Message-ID: 937d27e10810020604yce363eakc5c386697d1b9e2b@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-support
On Thu, Oct 2, 2008 at 1:58 PM, Ryan Daniels <ryan(dot)daniels(at)gmail(dot)com> wrote:
>
> When I run insert statements from the SQL window, the data seems to be
> commited automatically. Is this the case? I looked through the buttons and
> menu options of the window, but did not find any choices for commit and
> rollback. Is there an option somewhere that turns off auto-commit?
>
> If it is the case that auto-commit occurs, and there are no toolbar buttons
> to do this, can commit and rollback buttons be added in an upcomming
> version?

It follows the normal PostgreSQL behaviour. If you don't want to
commit immediately, issue a BEGIN first.


-- 
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com

In response to

Responses

pgadmin-support by date

Next:From: Dave PageDate: 2008-10-02 13:33:59
Subject: Re: PGAdmin Auto-commits?
Previous:From: Ryan DanielsDate: 2008-10-02 12:58:47
Subject: PGAdmin Auto-commits?

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