Re: 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 <clemens(dot)schwaighofer(at)e-graphics(dot)com>:
> 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 outside until the
> function is finished? I can see the changed data inside the function.
>
> the function looks something like this
>
> create or replace function insert_log(i_log_id INT, i_queue_id INT)
> returns "varchar"
> as $$
> declare
> [... here are record, etc declarations]
> begin
> for myrec in select * from queue where queue_id = i_queue_id;
> loop
> insert into log_sub () values ();
> update log set rows = [internal row count] where log_id = i_log_id;
> end loop
> end; $$ language plpgsql;
> --
> ★ Clemens 呉 Schwaighofer
> ★ IT Engineer/Web Producer/Planning
> ★ E-Graphics Communications SP Digital
> ★ 6-17-2 Ginza Chuo-ku, Tokyo 104-8167, JAPAN
> ★ Tel: +81-(0)3-3545-7706
> ★ Fax: +81-(0)3-3545-7343
> ★ http://www.e-gra.co.jp
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

--
------------
pasman