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: (view raw or whole thread)
Lists: pgsql-general
Hi. newbie question, but what will happen if I do

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

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.


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-2015 The PostgreSQL Global Development Group