Skip site navigation (1) Skip section navigation (2)

what happens if something goes wrong in transaction?

From: "A B" <gentosaker(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: what happens if something goes wrong in transaction?
Date: 2008-02-28 14:19:01
Message-ID: dbbf25900802280619g773b9ecdn1d9e6bdd4b07acc5@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
Hi. newbie question, but what will happen if I do

begin work;
select ...
insert ...
and so on...
commit

and somewhere a query fails. will I get an automatic rollback? If not, is
there a way to get that behaviour?
I'm using php to make all these calls and they have all to be succesfull or
no one of them should be carried out.

Responses

pgsql-general by date

Next:From: Martijn van OosterhoutDate: 2008-02-28 14:50:11
Subject: Re: beginner postgis question lat/lon
Previous:From: Merlin MoncureDate: 2008-02-28 13:38:26
Subject: Re: Can't start Postgres anymore

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group