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

[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