Re: Visibility of a local variable

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Visibility of a local variable
Дата
Msg-id CAKFQuwYBxmU8kw6zrZXdwWP85Y6n3WkrBhaboBVPjg3EyPJHrw@mail.gmail.com
обсуждение исходный текст
Ответ на Visibility of a local variable  (Alejandro Burne <adburne@gmail.com>)
Ответы Re: Visibility of a local variable
Список pgsql-bugs
On Monday, June 3, 2024, Alejandro Burne <adburne@gmail.com> wrote:
A local variable, created within a transaction, continues to persist (without value) after the transaction has ended.


This is under-documented but at present there is no plan to change this long-standing behavior, just document it better.

Once a session knows a variable exists it cannot be made to not exist.  Only set back to its default empty string value (since custom variables are only of type text)

David J.
 

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

Предыдущее
От: SAS
Дата:
Сообщение: Minor update on pg_hba documentation
Следующее
От: Pierre Forstmann
Дата:
Сообщение: Re: BUG #18494: hstore data type not recognized by Npgsql in PostgreSQL 16.3