Re: COMMIT in PostgreSQL

From: "Susan Lane" <suel(at)dpn(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: COMMIT in PostgreSQL
Date: 2002-07-19 21:06:18
Message-ID: ah9vnd$10aj$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)dpn(dot)com
Ph. (702) 873-3282
Fax (702) 873-3913
http://www.dpn.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Susan Lane 2002-07-19 21:14:10 Modifying column size
Previous Message Tom Lane 2002-07-19 20:57:26 Re: currval sequence memory storage?