Thread: Is missing LOGIN Event on Trigger Firing Matrix ?

Is missing LOGIN Event on Trigger Firing Matrix ?

From
Marcos Pegoraro
Date:
create event trigger ... on login is now available but it is not shown on DOCs or is it in another page ?

doesn't have it, should be there ?

regards
Marcos

Re: Is missing LOGIN Event on Trigger Firing Matrix ?

From
Andrew Dunstan
Date:


On 2024-06-27 Th 2:40 PM, Marcos Pegoraro wrote:
create event trigger ... on login is now available but it is not shown on DOCs or is it in another page ?

doesn't have it, should be there ?


It's not triggered by a statement. But see here:


https://www.postgresql.org/docs/devel/event-trigger-database-login-example.html


cheers


andrew


--
Andrew Dunstan
EDB: https://www.enterprisedb.com

Re: Is missing LOGIN Event on Trigger Firing Matrix ?

From
"David G. Johnston"
Date:
On Thu, Jun 27, 2024 at 12:39 PM Andrew Dunstan <andrew@dunslane.net> wrote:
On 2024-06-27 Th 2:40 PM, Marcos Pegoraro wrote:
create event trigger ... on login is now available but it is not shown on DOCs or is it in another page ?

doesn't have it, should be there ?


It's not triggered by a statement. But see here:


https://www.postgresql.org/docs/devel/event-trigger-database-login-example.html



I suggest adding a sentence and link from the main description [1] to that page.

We already do that for the ones that have commands:
"For a complete list of commands supported by the event trigger mechanism, see Section 38.2."

and login deserves something similar on that page.

David J.