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

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Andre Lopes <lopes80andre(at)gmail(dot)com>
Cc: Scott Ribe <scott_ribe(at)killerbytes(dot)com>, postgresql Forums <pgsql-general(at)postgresql(dot)org>
Subject: Re: It is possible to update more than 1 table in the same update statement?
Date: 2010-11-09 00:56:45
Message-ID: AANLkTikTAJekfC=DpE_fH+Di4ou24ufg8OhoK7LQLQDG@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Nov 8, 2010 at 5:39 PM, Andre Lopes <lopes80andre(at)gmail(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-11-09 01:29:28 Re: Removing pgsql_tmp files
Previous Message Andre Lopes 2010-11-09 00:39:41 Re: It is possible to update more than 1 table in the same update statement?