Re: [GENERAL] Questions regarding interaction of stored functions and transactions

2005-03-24 Thread Tom Lane
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 manip

[GENERAL] Questions regarding interaction of stored functions and transactions

2005-03-24 Thread Bill Moran
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 ('anot