On Sat, Feb 15, 2020 at 4:39 AM RekGRpth <rekgrpth(at)gmail(dot)com> wrote:
>
> And how about several transaction in new procedures?
>
That does seem like a legitimate gripe.
create or replace procedure foo() LANGUAGE plpgsql as $$
begin
FOR i IN 1..100 LOOP
perform pg_notify('channel','HI');
perform pg_sleep(1);
commit;
end loop;
end; $$;
CALL foo();
An actively polling listener gets all notification all at once at the end.
(I just use psql with a "LISTEN channel;" and the repeatedly execute ";" to
get it to poll)
Cheers,
Jeff