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