Re: turn off auto-commit - Mailing list pgsql-admin

From Björn Lundin
Subject Re: turn off auto-commit
Date
Msg-id al85pb$1hp6$1@news.hub.org
Whole thread Raw
In response to Re: turn off auto-commit  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: turn off auto-commit  ("Nick Fankhauser" <nickf@ontko.com>)
Re: turn off auto-commit  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-admin
Bruce Momjian wrote:

> Waruna Geekiyanage wrote:
>> Does turn fsync off equivalent to turn autocommit off?
>
> No, fsync is related to flushing information to disk. It doesn't relate
> to autocommit.
>
This auto-commit on/off, is this what I think it is;
a way off NOT needing to enclose several statements in a begin/commit,
but having a new transaction directly after a commit, in psql, like
Oracle's sql*plus?

If so, in what version was this introduced, or is this mentioned somewhere
on the web?

regards
/Björn Lundin

pgsql-admin by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: HELP !!!! Deleted the content of bin directory
Next
From: Artur Pietruk
Date:
Subject: Re: I need ODBC for PostgreSQL