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