Обсуждение: Re: [PATCHES] Win32 CHECK_FOR_INTERRUPTS() performance

Tom wrote:
> "Merlin Moncure" <merlin.moncure@rcsonline.com> writes:
> > 3.  A pl/pgsql function stuck in a empty loop is unkillable except
by
> > killing the process on the server, which cycles the entire server.
This
> > was the behavior before the patch, btw.
>
> Hmm, that suggests we need another CHECK_FOR_INTERRUPTS somewhere in
> plpgsql.  Please show the exact test case you were using.

create function test_func() returns int4 as $$ BEGIN LOOP END LOOP;
select 0; END; $$ language plpgsql;

select test_func(); // :-).

"Merlin Moncure" <merlin.moncure@rcsonline.com> writes:
> Tom wrote:
>> Hmm, that suggests we need another CHECK_FOR_INTERRUPTS somewhere in
>> plpgsql.  Please show the exact test case you were using.

> create function test_func() returns int4 as $$ BEGIN LOOP END LOOP;
> select 0; END; $$ language plpgsql;

Thanks, fixed.
        regards, tom lane