Re: Bug in Configuration Setting Functions after a Commit
| От | David G. Johnston |
|---|---|
| Тема | Re: Bug in Configuration Setting Functions after a Commit |
| Дата | |
| Msg-id | CAKFQuwaWMy7NKqF4z3anLvvPbQRBGrtki4L5UmSziR5oo08yaQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Bug in Configuration Setting Functions after a Commit (João felipe Chiarelli Bourscheid <joao.felipe.c.b@gmail.com>) |
| Ответы |
Re: Bug in Configuration Setting Functions after a Commit
|
| Список | pgsql-bugs |
On Mon, Feb 24, 2025 at 11:32 AM João felipe Chiarelli Bourscheid <joao.felipe.c.b@gmail.com> wrote:
The bug is the following: when I set a custom variable using the configuration settings functions within a transaction, after I commit the transaction, instead of the variable becoming null, it becomes an empty string.
Yes, this is working as designed. The variable will never take on the null value, and the system won't forget that it exists once created, so the default value of empty string is restored when the transaction ends.
There is some work-in-progress to clarify this in the documentation.
David J.
В списке pgsql-bugs по дате отправления: