Re: [BUGS] Transactions and "create or replace function"

2005-04-23 Thread Tom Lane
Ron Mayer <[EMAIL PROTECTED]> writes: > I would have expected that since the CREATE OR REPLACE was > in a separate connection, and hense a separate transaction, > that all the results of the select() will have been processed > by the same function. System catalog accesses are generally done with S

[BUGS] Transactions and "create or replace function"

2005-04-22 Thread Ron Mayer
I have a long query something like select slow_function(col) from large_table; and half way through the query, in a separate connection, I CREATE OR REPLACE slow_function I was surprised to see that some of the rows in my select were processed by the old definition and some by the new. I w