Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rwbxK-002wP6-RZ for pgsql-hackers@arkaria.postgresql.org; Tue, 16 Apr 2024 06:06:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rwbxJ-001B9n-BB for pgsql-hackers@arkaria.postgresql.org; Tue, 16 Apr 2024 06:06:09 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rwbxI-001B7g-DY for pgsql-hackers@lists.postgresql.org; Tue, 16 Apr 2024 06:06:09 +0000 Received: from mail-me3aus01olkn2156.outbound.protection.outlook.com ([40.92.63.156] helo=AUS01-ME3-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rwbxD-001CyL-CR for pgsql-hackers@lists.postgresql.org; Tue, 16 Apr 2024 06:06:07 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=RLmf57jE7/6vtwFgK08OhRL3buhrh7fm8ImyDiXuYCqCnBypyZ0D/GfSzGjmRzJdfnYdxZdDuFPCliuiDfdi6gMNiRFOL2Z15iLvtXM1hdA3adil+I0CWsARdoKIK2PySUAjcZ924lwwhqODjjqNkZGB0W1xB3TyQokjRMD3MhyOSiprv2wat25JaWD/XgwBaBrmWSRhhgD3XEWwpcEEkkd3HeR70OYvFOIuAylrPhenBjaLtvYoBP/hoRQiHguKynn7RWZxp1J5SSk+LAdWM8brAK45rA3gGROw5krWJSDMaH7fIdn01Z6hdYYwzMAhCtWhlpmZDkcnCh3FVdbF/A== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=Gm1X4gokJtY9YmaWh0odxBoqDN5O0pYdSlW0YUb7I88=; b=ADffxi/AO8VcPfUw5x0n/BmH8IZNPYbdUM//86yd0Zvplj9twZmFlv9s6augmCJ1Fo4o/dlkvySPXEsQbLPXKpjtJwPdEqar+ouoqYQz1iAkvJraqiBoloX05dM0r2/x4p1Yx+ryC4Qsd2yg/Ym2MOfI36moEbPxdqHiwiE5j69H7Qht0wNz7gbpgKMBASsIj8iW3WBRste9S4FRbgsmi0q7AbI3E/QA63g/Fjsy/uLSYSBw3s9gwJXyuvSI+I9tTZz5casxP0kU+KBnLVEqqUZOLHZd6kDs79xGZj6Jv8G9CnOh1quT6QoKeuWe15UKrRI/ViLBFrjQh3HeL0urHw== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=hotmail.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=Gm1X4gokJtY9YmaWh0odxBoqDN5O0pYdSlW0YUb7I88=; b=pEJcRSEdEY70phtLW0TwgVfbwHXQ7EKppnZefGfJfNwlC5cAyAYGNFZZB4j+xOXgrUgWB0WiMujYxv/zD0bhvKPfQZCmkL9zNoA9jvmIYKujQWQKLRSL+nkV0rCj4u/CCtSISCq0aAsd3Bri2CIwHvBiet4qR6lJH/bU067TnfQGcTFIqE4dfxdU9RflGz/11sa3fE43TXwYgHxEKS54BiFSMNri44yqtYlSgw138vAEAh/Wkep+4iOyMdHSjN9H/+K4HNqdCF5YVfqtAzrfr0VV+cELA2QtWsel0KgCBGH8wW+/E2AEvks/y9KR61BjRks4zyAQ2DHLxOECns1A7A== Received: from ME3P282MB3166.AUSP282.PROD.OUTLOOK.COM (2603:10c6:220:147::21) by ME3P282MB0929.AUSP282.PROD.OUTLOOK.COM (2603:10c6:220:86::10) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.7452.50; Tue, 16 Apr 2024 06:05:57 +0000 Received: from ME3P282MB3166.AUSP282.PROD.OUTLOOK.COM ([fe80::4158:743a:ffd4:1274]) by ME3P282MB3166.AUSP282.PROD.OUTLOOK.COM ([fe80::4158:743a:ffd4:1274%4]) with mapi id 15.20.7452.049; Tue, 16 Apr 2024 06:05:57 +0000 User-agent: mu4e 1.4.15; emacs 28.1 From: Japin Li To: PostgreSQL Hackers Subject: Typo about the SetDatatabaseHasLoginEventTriggers? Date: Tue, 16 Apr 2024 14:05:46 +0800 Message-ID: Content-Type: text/plain X-TMN: [ccV9d1W7pjPeDX9qbF5g+OUzjDs2M/s+BZZcaqIehBY=] X-ClientProxiedBy: TYAPR01CA0077.jpnprd01.prod.outlook.com (2603:1096:404:2c::17) To ME3P282MB3166.AUSP282.PROD.OUTLOOK.COM (2603:10c6:220:147::21) X-Microsoft-Original-Message-ID: <87pluplu4l.fsf@hotmail.com> MIME-Version: 1.0 X-MS-Exchange-MessageSentRepresentingType: 1 X-MS-PublicTrafficType: Email X-MS-TrafficTypeDiagnostic: ME3P282MB3166:EE_|ME3P282MB0929:EE_ X-MS-Office365-Filtering-Correlation-Id: 8e1a3237-7906-4fbf-bd7e-08dc5ddb47ec X-Microsoft-Antispam: BCL:0; X-Microsoft-Antispam-Message-Info: xExeqv5sAAHr1cBVTtjjyiMoHXHkM3ObQ5dlxxB0HCz5+kQaJnr+twpZTchDn2raiRgBaRddRps1rFayu5DEZFkPA6DmS+RQr8dyoQFacK2OI9LWuDq7p5yZ52ZcqUB+XjbnLY0/Uvf5kcUHnNAcGsZOgVxjGmjTYjyNJ+ny81qddUOdP997EE+jZW+9oZEbwNgxxWNLlzKJF1Ixd4s8xjwwMD6B2pbdYBJN4TlxfLclN52yXZPRIZvgGE9ny1HSBMwiYJFbgG60+wUa4YgYDWDnVIu7PpCqZjpbCaOt2OJY1LrOq8Fzr8WB8jBYZaBj4PTeMiILf2/Z1E6SaIZW0gZLyqRg3zS/tCbr6FO5mqcOHDnE1LuGkQcsk+5lU9N4Zh4bN/bQXWeYJbZb/BCPmr4mP2edjCLCjBI82lX12JuyDhIYFiKltwCo7Uy8zsdKz5py+vcHP23wLETF5Bkq9uSaa9mZK6e96mMwHfwR393dhuw07Mb0LR+AKytvp1unb2O5agcvmCFvNXhLvv+ZlT0UKNDITy1Ez3OkDbKpsABMpw5hOHTUmL6Xra5rQzUi X-MS-Exchange-AntiSpam-MessageData-ChunkCount: 1 X-MS-Exchange-AntiSpam-MessageData-0: =?us-ascii?Q?qEJDjWS5ViL4+QEWSoK5caxSf2asX3VFSqhlIYVn3XPe6hxn4YrZj/0oBesL?= =?us-ascii?Q?SYeX6h/XsZ/XrCKM4G7xuaxp+4bT1fJw5IXRX1k/y80n8GeqYD5rrEyqwUT0?= =?us-ascii?Q?zTIRIZDTASuozSJJmlFNtOd0XAmB2qjpVcuLGWrx/AdtxFLdaf5mSGUuUMCK?= =?us-ascii?Q?Lq/wfsFVkTVdArFmjv35GvDwfOMaRECQ1IDnwgJ0VlkCJQBvtiY+TqU6YfKb?= =?us-ascii?Q?ZhlMtAq2yDSfJ6xfp34kBIy5UBYoZxFDjHs958NhpDEM3Zj/lwp7KUsfZDoe?= =?us-ascii?Q?o/wEiXr6xNBEmun7hi5jgEyfrhjucck8yK6J3xDKqZRjVSLK6LLy8V7j/9Nh?= =?us-ascii?Q?rEAa96p9HL0ehvQILpjjZLEVSHMgmEk5/ofE4drq1rswrIowqqmgeKaIuQLP?= =?us-ascii?Q?j+V653VSM8Agicg8yVzyMxbw3BV2xDo95MthqKQbcVpKaf8U3RIQ4uXADYzo?= =?us-ascii?Q?NlZxeEClpJuJBMdeAfT0hKjNQbaRLeZIpfU9MI0wp7h41U1UrWBwFqsgrxry?= =?us-ascii?Q?+1E2MFLjUaqysqxHR0vkNUbbVVwTBzUL03ge8UPWSP0ws88klJCbHtiI7CMJ?= =?us-ascii?Q?zrspEdl0m/z065IrufBOLm/AaXjExRMSo92p9KsDWcxRw4ojbIb4aNkYyADF?= =?us-ascii?Q?vOnrzh6x4m/OhVh3wBaTu8SjJf7EVI1Yl3MM5zEtlW0TaJd2lchj+RVKbCMf?= =?us-ascii?Q?PULeA1qJpthGGjOTfiRLZbk6kghh8fBVFH+sBIQhqnD7pkJpvLJizqFWHzvX?= =?us-ascii?Q?b/l3f8EDAtmHlTA1xhlTFnMTQZRk0HYgocvmPi2nFHRfAnxmj8ifwtqLvOhD?= =?us-ascii?Q?1TLBQk1arcK9r7iez4ZtIAlsuPs40OKGzZSKywUxDWjDM9YIVCq0Sqa2hfJ7?= =?us-ascii?Q?RIIZ8vV6Uxi6DWmYkt4YyDLbVNYptbHq3Ntu3AK7EVznYLY0LsVvidojpg3Y?= =?us-ascii?Q?pY5WfiQ9XGMo6RkyuNvlHNGJtkE9OtZ4Z9SFv9lHjATJylFU1L6Tf6yR2imP?= =?us-ascii?Q?Lf3nJeZ4YX1/ciHC+FgZWBs/dEbZFLj8PblJrGIZFuQLkS+XWR/9fWg0PHZK?= =?us-ascii?Q?Gct3ob2qH8T2ZOw/KrBZweCIJia9u+Lan8Zi9s4/oTSwoIKyb0Cf4rKRoVkp?= =?us-ascii?Q?QMT1f4D1E7NgCy3sUso2L0k0tWTI0FInvm6R7iwYy7GpRnZpMeXjpavPoj6P?= =?us-ascii?Q?Shf8a9F33+CKUtcO8wKlIfyQVPowjshW0FLLlPlza7LI2jJw3CvzXFWQP7U?= =?us-ascii?Q?=3D?= X-OriginatorOrg: sct-15-20-4755-11-msonline-outlook-746f3.templateTenant X-MS-Exchange-CrossTenant-Network-Message-Id: 8e1a3237-7906-4fbf-bd7e-08dc5ddb47ec X-MS-Exchange-CrossTenant-AuthSource: ME3P282MB3166.AUSP282.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-OriginalArrivalTime: 16 Apr 2024 06:05:57.5166 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-CrossTenant-Id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-Transport-CrossTenantHeadersStamped: ME3P282MB0929 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, Upon reviewing the login event trigger, I noticed a potential typo about the SetDatabaseHasLoginEventTriggers function name. diff --git a/src/backend/commands/event_trigger.c b/src/backend/commands/event_trigger.c index 0d3214df9c..7a5ed6b985 100644 --- a/src/backend/commands/event_trigger.c +++ b/src/backend/commands/event_trigger.c @@ -111,7 +111,7 @@ static void validate_table_rewrite_tags(const char *filtervar, List *taglist); static void EventTriggerInvoke(List *fn_oid_list, EventTriggerData *trigdata); static const char *stringify_grant_objtype(ObjectType objtype); static const char *stringify_adefprivs_objtype(ObjectType objtype); -static void SetDatatabaseHasLoginEventTriggers(void); +static void SetDatabaseHasLoginEventTriggers(void); /* * Create an event trigger. @@ -315,7 +315,7 @@ insert_event_trigger_tuple(const char *trigname, const char *eventname, Oid evtO * faster lookups in hot codepaths. Set the flag unless already True. */ if (strcmp(eventname, "login") == 0) - SetDatatabaseHasLoginEventTriggers(); + SetDatabaseHasLoginEventTriggers(); /* Depend on owner. */ recordDependencyOnOwner(EventTriggerRelationId, trigoid, evtOwner); @@ -383,7 +383,7 @@ filter_list_to_array(List *filterlist) * current database has on login event triggers. */ void -SetDatatabaseHasLoginEventTriggers(void) +SetDatabaseHasLoginEventTriggers(void) { /* Set dathasloginevt flag in pg_database */ Form_pg_database db; @@ -453,7 +453,7 @@ AlterEventTrigger(AlterEventTrigStmt *stmt) */ if (namestrcmp(&evtForm->evtevent, "login") == 0 && tgenabled != TRIGGER_DISABLED) - SetDatatabaseHasLoginEventTriggers(); + SetDatabaseHasLoginEventTriggers(); InvokeObjectPostAlterHook(EventTriggerRelationId, trigoid, 0); @@ -925,7 +925,7 @@ EventTriggerOnLogin(void) /* * There is no active login event trigger, but our * pg_database.dathasloginevt is set. Try to unset this flag. We use the - * lock to prevent concurrent SetDatatabaseHasLoginEventTriggers(), but we + * lock to prevent concurrent SetDatabaseHasLoginEventTriggers(), but we * don't want to hang the connection waiting on the lock. Thus, we are * just trying to acquire the lock conditionally. */ -- Regards, Japin Li