Re: [GENERAL] plpgsql function with update and seeing changed data from outside during run

2011/6/9 Tom Lane : > Merlin Moncure writes: >> On Thu, Jun 9, 2011 at 4:46 AM, Craig Ringer >> wrote: >>> (as far as I know) It's not possible for a function to see data committed by >>> other transactions since that function began executing, whether or not those >>> other transactions have comm

Re: [GENERAL] plpgsql function with update and seeing changed data from outside during run

Merlin Moncure writes: > On Thu, Jun 9, 2011 at 4:46 AM, Craig Ringer > wrote: >> (as far as I know) It's not possible for a function to see data committed by >> other transactions since that function began executing, whether or not those >> other transactions have committed. > This is not corre

Re: [GENERAL] plpgsql function with update and seeing changed data from outside during run

On Thu, Jun 9, 2011 at 4:46 AM, Craig Ringer wrote: > On 9/06/2011 2:41 PM, Clemens Schwaighofer wrote: >> >> Hi, >> >> I have a plpgsql function where I read data from a table in a loop and >> update data in a different table. >> >> Is it possible to see the updated data from a different access d

Re: [GENERAL] plpgsql function with update and seeing changed data from outside during run

2011/6/9 Craig Ringer : > On 9/06/2011 2:41 PM, Clemens Schwaighofer wrote: >> >> Hi, >> >> I have a plpgsql function where I read data from a table in a loop and >> update data in a different table. >> >> Is it possible to see the updated data from a different access during >> the run of this func

Re: [GENERAL] plpgsql function with update and seeing changed data from outside during run

On 9/06/2011 2:41 PM, Clemens Schwaighofer wrote: Hi, I have a plpgsql function where I read data from a table in a loop and update data in a different table. Is it possible to see the updated data from a different access during the run of this function? Or is this impossible because the functi

Re: [GENERAL] plpgsql function with update and seeing changed data from outside during run

I can try this, but I have never done anything with plperl yet. 2011/6/9 pasman pasmański : > If you rewrite your function in plperlu , you can store data in shared memory. > > 2011/6/9, Clemens Schwaighofer : >> Hi, >> >> I have a plpgsql function where I read data from a table in a loop and >> u

Re: [GENERAL] plpgsql function with update and seeing changed data from outside during run

If you rewrite your function in plperlu , you can store data in shared memory. 2011/6/9, Clemens Schwaighofer : > Hi, > > I have a plpgsql function where I read data from a table in a loop and > update data in a different table. > > Is it possible to see the updated data from a different access du

[GENERAL] plpgsql function with update and seeing changed data from outside during run

Hi, I have a plpgsql function where I read data from a table in a loop and update data in a different table. Is it possible to see the updated data from a different access during the run of this function? Or is this impossible because the function is a "transaction" and no data change is visible