Re: COMMIT in PostgreSQL - Mailing list pgsql-general

From Tom Jenkins
Subject Re: COMMIT in PostgreSQL
Date
Msg-id 1027113380.6793.141.camel@asimov
Whole thread Raw
In response to Re: COMMIT in PostgreSQL  ("Susan Lane" <suel@dpn.com>)
List pgsql-general
On Fri, 2002-07-19 at 17:06, Susan Lane wrote:
> > > > AFAIAA each query sent to the backend is a transaction and is treated
> as
> > > > such unless you explicitly send a BEGIN.
> > > >
> > > > If you send a BEGIN then you can send multiple INSERTS etc and then do
> a
> > > > manual COMMIT.
>
> I have noticed this difference between Postgres and Oracle as well.  I
> wonder if there is a rollback mechanism as there is in Oracle.  I mean if
> you use a BEGIN, can you rollback in Postgres?
>

Yes

--

Tom Jenkins
Development InfoStructure
http://www.devis.com



pgsql-general by date:

Previous
From: "Susan Lane"
Date:
Subject: Modifying column size
Next
From: Andrew Sullivan
Date:
Subject: Re: Modifying column size