plpgsql function with update and seeing changed data from outside during run
От | Clemens Schwaighofer |
---|---|
Тема | plpgsql function with update and seeing changed data from outside during run |
Дата | |
Msg-id | BANLkTim5YWwwCxdpL4rEQrFuqE5FJvQSYQ@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: plpgsql function with update and seeing changed data
from outside during run
Re: plpgsql function with update and seeing changed data from outside during run |
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: