Is missing LOGIN Event on Trigger Firing Matrix ?
create event trigger ... on login is now available but it is not shown on
DOCs or is it in another page ?
https://www.postgresql.org/docs/devel/event-trigger-matrix.html
doesn't have it, should be there ?
regards
Marcos
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 ?https://www.postgresql.org/docs/devel/event-trigger-matrix.html
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
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 ?https://www.postgresql.org/docs/devel/event-trigger-matrix.html
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]https://www.postgresql.org/docs/devel/event-trigger-definition.html 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.
[1]: https://www.postgresql.org/docs/devel/event-trigger-definition.html
On 27 Jun 2024, at 22:00, David G. Johnston <david.g.johnston@gmail.com> wrote:
I suggest adding a sentence and link from the main description [1] to that page.
How about the attached.
--
Daniel Gustafsson
Attachments:
login_evt_link.diffapplication/octet-stream; name=login_evt_link.diff; x-unix-mode=0644Download
diff --git a/doc/src/sgml/event-trigger.sgml b/doc/src/sgml/event-trigger.sgml
index 8e009cca05..b76e401775 100644
--- a/doc/src/sgml/event-trigger.sgml
+++ b/doc/src/sgml/event-trigger.sgml
@@ -54,6 +54,11 @@
the in-progress <literal>login</literal> trigger.
</para>
+ <para>
+ For an example on how to use the <literal>login</literal> event trigger
+ see <xref linkend="event-trigger-database-login-example"/>.
+ </para>
+
<para>
The <literal>ddl_command_start</literal> event occurs just before the
execution of a <literal>CREATE</literal>, <literal>ALTER</literal>, <literal>DROP</literal>,