I can try this, but I have never done anything with plperl yet.
2011/6/9 pasman pasmański <pasman.p@gmail.com>:
> If you rewrite your function in plperlu , you can store data in shared memory.
>
> 2011/6/9, Clemens Schwaighofer <clemens.schwaighofer@e-graphics.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@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>>
>
>
> --
> ------------
> pasman
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
★ 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
