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 по дате отправления:

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: Adding "quota user limit" using triggers
Следующее
От: Radosław Smogura
Дата:
Сообщение: Re: Best Practices - Securing an Enterprise application using JBOSS & Postgres