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