what happens if something goes wrong in transaction? - Mailing list pgsql-general

From A B
Subject what happens if something goes wrong in transaction?
Date
Msg-id dbbf25900802280619g773b9ecdn1d9e6bdd4b07acc5@mail.gmail.com
Whole thread Raw
Responses Re: what happens if something goes wrong in transaction?
Re: what happens if something goes wrong in transaction?
List 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.

pgsql-general by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: Can't start Postgres anymore
Next
From: Martijn van Oosterhout
Date:
Subject: Re: beginner postgis question lat/lon