Re: INSERT or UPDATE - Mailing list pgsql-general

From James B. Byrne
Subject Re: INSERT or UPDATE
Date
Msg-id 60357.65.92.52.21.1239064967.squirrel@webmail.harte-lyne.ca
Whole thread Raw
In response to Re: INSERT or UPDATE  ("Dann Corbit" <DCorbit@connx.com>)
Responses Re: INSERT or UPDATE
List pgsql-general
On Mon, April 6, 2009 20:23, Dann Corbit wrote:

>
> If a transaction involves rows where some succeed and some fail,
> all will roll back. If that is the desired behavior, or if all
> operations are singleton, then you won't see any problems.
>

Do I understand correctly that this means that even if the function
"handles" a failed insert then if the function occurs inside a
transaction then that transaction fails and is rolled back
regardless?


--
***          E-Mail is NOT a SECURE channel          ***
James B. Byrne                mailto:ByrneJB@Harte-Lyne.ca
Harte & Lyne Limited          http://www.harte-lyne.ca
9 Brockley Drive              vox: +1 905 561 1241
Hamilton, Ontario             fax: +1 905 561 0757
Canada  L8E 3C3


pgsql-general by date:

Previous
From: Ivan Sergio Borgonovo
Date:
Subject: media server (mp3 player) on postgresql
Next
From: "Dann Corbit"
Date:
Subject: Re: INSERT or UPDATE