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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-general by date

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