Re: COMMIT in PostgreSQL

> > > 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