Tom Lane <[EMAIL PROTECTED]> wrote:
> 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.
You're right, Tom. I can't get a simplified reproduction of the problem.
That means that the problem is occurring somewhere else in my program.
--
Bill Moran
Potential Technologies
http://www.potentialtech.com
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
