what happens if something goes wrong in transaction?

Поиск
Список
Период
Сортировка
От A B
Тема what happens if something goes wrong in transaction?
Дата
Msg-id dbbf25900802280619g773b9ecdn1d9e6bdd4b07acc5@mail.gmail.com
обсуждение исходный текст
Ответы Re: what happens if something goes wrong in transaction?
Re: what happens if something goes wrong in transaction?
Список 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 по дате отправления:

Предыдущее
От: "Merlin Moncure"
Дата:
Сообщение: Re: Can't start Postgres anymore
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: beginner postgis question lat/lon