Postgres Pro
Downloads
Home   >   mailing lists

Re: It is possible to update more than 1 table in the same update statement? - Mailing list pgsql-general

From Scott Marlowe
Subject Re: It is possible to update more than 1 table in the same update statement?
Date
Msg-id AANLkTikTAJekfC=DpE_fH+Di4ou24ufg8OhoK7LQLQDG@mail.gmail.com
Whole thread Raw
In response to Re: It is possible to update more than 1 table in the same update statement?  (Andre Lopes <lopes80andre@gmail.com>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Andre Lopes
Date:
Subject: Re: It is possible to update more than 1 table in the same update statement?
Next
From: Tom Lane
Date:
Subject: Re: Removing pgsql_tmp files