Bill Moran <[EMAIL PROTECTED]> writes:
> 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.
Sorry, I don't believe a word of that. If the first insert fails,
everything will be rejected until COMMIT.
Possibly you need to show a less fictionalized version of your problem.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
