Re: COMMIT in PostgreSQL

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