Re: Bug in Configuration Setting Functions after a Commit - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: Bug in Configuration Setting Functions after a Commit
Date
Msg-id CAKFQuwaWMy7NKqF4z3anLvvPbQRBGrtki4L5UmSziR5oo08yaQ@mail.gmail.com
Whole thread Raw
In response to Bug in Configuration Setting Functions after a Commit  (João felipe Chiarelli Bourscheid <joao.felipe.c.b@gmail.com>)
Responses Re: Bug in Configuration Setting Functions after a Commit
List 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 by date:

Previous
From: João felipe Chiarelli Bourscheid
Date:
Subject: Bug in Configuration Setting Functions after a Commit
Next
From: João felipe Chiarelli Bourscheid
Date:
Subject: Re: Bug in Configuration Setting Functions after a Commit