Re: BUG #16258: exec_simple_query does not call ProcessCompletedNotifies after CommitTransactionCommand

Thanks for the tip! I learned outer code of function exec_simple_query and
I seen "idle" condition of calling ProcessCompletedNotifies! In my postgres
job scheduler https://github.com/RekGRpth/pg_task I copied
exec_simple_query and modified it to call ProcessCompletedNotifies after
CommitTransactionCommand and it works!
with bst regrds, Rek>pth

сб, 15 февр. 2020 г. в 23:16, Jeff Janes <jeff(dot)janes(at)gmail(dot)com>:

> 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
>