Re: It is possible to update more than 1 table in the same update statement?

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: It is possible to update more than 1 table in the same update statement?
Дата
Msg-id AANLkTikTAJekfC=DpE_fH+Di4ou24ufg8OhoK7LQLQDG@mail.gmail.com
обсуждение исходный текст
Ответ на Re: It is possible to update more than 1 table in the same update statement?  (Andre Lopes <lopes80andre@gmail.com>)
Список pgsql-general
On Mon, Nov 8, 2010 at 5:39 PM, Andre Lopes <lopes80andre@gmail.com> wrote:
> Hi,
>
> Thanks for the reply.
>
> I have write the transaction, but I have some doubt's... If in this example
> the Update is executed successfully and the Function it is not, what
> happens? The Update automatically rolls back?

Yes, transactions (without savepoints) are all or nothing.

В списке pgsql-general по дате отправления:

Предыдущее
От: Andre Lopes
Дата:
Сообщение: Re: It is possible to update more than 1 table in the same update statement?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Removing pgsql_tmp files