> On 13 Jan 2024, at 17:00, Alexander Lakhin <exclusion@gmail.com> wrote:
> DROP EVENT TRIGGER olt;
> SELECT dathasloginevt FROM pg_database WHERE datname= current_database();
> dathasloginevt
> ----------------
> t
> (1 row)
>
> Although after reconnection (\c, as done in the event_trigger_login test),
> this query returns 'f'.
This is by design in the patch. The flag isn't changed on DROP, it is only
cleared on logins iff there is no login event trigger. The description in the
docs is worded to indicate that it shouldn't be taken as truth for monitoring
purposes:
"This flag is used internally by PostgreSQL and should not be manually
altered or read for monitoring purposes."
--
Daniel Gustafsson