I'm a little fuzzy on this, and I've been unable to find docs that clear it up for me. A pointer to a helpful doc would be just as welcome as an outright explanation ;)
Let's take the following fictional scenerio: BEGIN; INSERT INTO table1 VALUES ('somestring'); INSERT INTO table1 VALUES ('anotherstring'); SELECT user_defined_function(); COMMIT; In this case, user_defined_function() does a lot more table manipulation. I don't want that to be done if any statement prior fails, but it seems as if it's always done, regardless. It seems as if the second INSERT is not executed if the first fails, but the function is always called. So ... I'm a little fuzzy on this. Is there a doc that details this behaviour? TIA. -- Bill Moran Potential Technologies http://www.potentialtech.com ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq