BUG #17837: The potential risks associated with executing "commit" in a procedure.

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #17837: The potential risks associated with executing "commit" in a procedure.
Дата
Msg-id 17837-9e65be9846767162@postgresql.org
обсуждение исходный текст
Ответы Re: BUG #17837: The potential risks associated with executing "commit" in a procedure.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      17837
Logged by:          Andre Lin
Email address:      857348270@qq.com
PostgreSQL version: 12.14
Operating system:   Linux x86_64 GNU/Linux
Description:

Recently, I have noticed that executing "commit" in a procedure calls
PreCommit_Portals in the kernel, which sets the resowner of the top level
portal to null. However, subsequent statements still use this portal, and
its resowner remains null. Is there any risk associated with this or could
it lead to unexpected behavior? If this is expected, how should I interpret
(or ... understand) portal->resowner? I would greatly appreciate your
guidance on this matter.

For example:

create or replace procedure p () 
as
$$
    declare
    vsql varchar := 'aa';
    begin
        for i in 1..10
        loop
            raise notice '%',i;
        end loop;
    commit;
        for i in 1..10
        loop
        raise notice '%',i;
        end loop;
    commit;
end;
$$
language plpgsql;


В списке pgsql-bugs по дате отправления:

Предыдущее
От: Dean Rasheed
Дата:
Сообщение: Re: BUG #17792: MERGE uses uninitialized pointer and crashes when target tuple is updated concurrently
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #17835: Two assertions failed in nodeAgg.c and execExprInterp.c with the same SQL