Re: [GENERAL] Questions regarding interaction of stored functions

2005-03-27 Thread Bill Moran
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

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

Re: [GENERAL] Questions regarding interaction of stored functions

2005-03-24 Thread Joshua D. Drake
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

[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