Re: COMMIT in PostgreSQL - Mailing list pgsql-general

From Susan Lane
Subject Re: COMMIT in PostgreSQL
Date
Msg-id ah9vnd$10aj$1@news.hub.org
Whole thread Raw
In response to Re: COMMIT in PostgreSQL  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: COMMIT in PostgreSQL
Re: COMMIT in PostgreSQL
List pgsql-general
> > > 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?

--
Susan Lane
DPN, Incorporated
4631 Spring Mountain Road
Las Vegas, NV 89102
Email  suel@dpn.com
Ph. (702) 873-3282
Fax (702) 873-3913
http://www.dpn.com



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: currval sequence memory storage?
Next
From: "Susan Lane"
Date:
Subject: Modifying column size