References: <ME3P282MB316614DBFF1CB7F7EB4C6C0AB60D2@ME3P282MB3166.AUSP282.PROD.OUTLOOK.COM>
 <2174635.1713548194@sss.pgh.pa.us>
User-agent: mu4e 1.4.15; emacs 28.1
From: Japin Li <japinli@hotmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>, Song JinZhou
 <tsinghualucky912@foxmail.com>
Subject: Re: Support event trigger for logoff
In-reply-to: <2174635.1713548194@sss.pgh.pa.us>
Date: Mon, 22 Apr 2024 21:24:29 +0800
Message-ID:
 <ME3P282MB31668D70A037A2189ABF2419B6122@ME3P282MB3166.AUSP282.PROD.OUTLOOK.COM>
Content-Type: text/plain
MIME-Version: 1.0
X-MS-Exchange-MessageSentRepresentingType: 1
X-MS-PublicTrafficType: Email
X-MS-TrafficTypeDiagnostic: ME3P282MB3166:EE_|SY4P282MB4235:EE_
X-MS-Office365-Filtering-Correlation-Id: c49a8dfb-4d55-431d-e622-08dc62cf8cf1
X-Microsoft-Antispam: BCL:0;
X-Microsoft-Antispam-Message-Info:
	a5477U5GQ4KIHTnEZxm0lSFEdtbSVz8gpSOAqCDj4WKw53Buh71UgKJXOpAru33zYb1X7Dg/336+5G59ZEE22YZkhzVzntLxjnfbCp8ylhD6MEFa/OnEQrhQYxDnwvdJnGYwOoQUKIJNLxdr19U01lZxp7MX9CSFIMjUV8yuNPlVdUVGyMzu7vf8Hm6mkDJm28S+j2D1qTfT/aVin6a4EBfyYiquGA0ls1j6RR5GnH5RIQ2KbwwMBbP/gK+6dm951iUA2uBDaD8hX3ia/lyXLy8a8lTFOT1/zv8CvuoqE9jn4vuM0noFZcBoDbHuFSB+w7oPyZMMVFTyjddVcKCAmdK6RwmbWVy/MmpfjHtPRar0XPs7OF8saWvrbQahfvtlg+mY5RtTRIH8GDCSI4PBSV4TuHhfoFac/dQjddleWbx/szih5sMcapgX3nRxqd1EG/J4PIflV0gypiRMPWJbBSM9A+IYzIis/+1ZndK8fxS5JwwhQxNab/78pC4kkxMTOr1iKCnVobJ7Vs+JEsUKW2xMfmoyxlPqaRSGAwEeiUt3l2L1+Skca4SebzYTNSP6
X-MS-Exchange-AntiSpam-MessageData-ChunkCount: 1
X-MS-Exchange-AntiSpam-MessageData-0:
	=?us-ascii?Q?M3wO/4qe+GiTeY33M70KIn7f4xM1gV1IYArZt0wOArOzRJ1SPBoX7nJ6ZtXP?=
 =?us-ascii?Q?xifAQfCNK2MW27gtJJXtcpyhN2+D5XpW2Vjz+PDhgZ2adtfPJWHT5Tr0FvOF?=
 =?us-ascii?Q?6KyO8A79f6n9uk/pdQJGZ1m1G5zthSp3AM6dKsZSMLMqFP3CYc0RraXONkGM?=
 =?us-ascii?Q?pp5QOZp8HPWpHOVUYZseZvS7LR4n6qnj1EYbFtoS3/E2Q0VNAvwpmRJDuW7I?=
 =?us-ascii?Q?FjGtGrhsG3oOH0FGaksARRv0/MgzQ5HOlXoXY3x0CBfvbZ9d6fpN1Bj2Vad/?=
 =?us-ascii?Q?y/7N3zqRjzmr4qmHhwRsHeVYFlSsp/Na451xZfGRyybSvRVDMD2RTci54+EQ?=
 =?us-ascii?Q?oo5qe2BR8eB786dIVZaIXP3vpzT7CNQLpHrB5IZ3oZqXEw15uM+ksyDVE6Ia?=
 =?us-ascii?Q?EsQyGHmgVAJzd7/roRSAcJXlVGG8seyKn5JpYDM7rM7IYbJ6rwxjZo2ceSNe?=
 =?us-ascii?Q?tbK9ku3nJ93AExA6u+iSaamX3ncRIR96clOvnh7lhWSyvXeTmq69qQcTvpKE?=
 =?us-ascii?Q?cd56kgCh7KNMtNSFNJl030wcOxJHxTNp1ke3vtpbTtVHqLGPzRggL54Jkdma?=
 =?us-ascii?Q?zXkx1Awd66Q3CVQmz3xaaqSlEg5XKBCf+s20wQ3M7d1AFkUDTJeZFiV470Sc?=
 =?us-ascii?Q?TgXW8QcXjvBXfnSOE68IvoHUIGBcNk9WNTyAt/Gua1Nd+AFWPqRFQx/uqMO7?=
 =?us-ascii?Q?wXz4cw4IjxJzlQgn8RXuGoHD22KHtvPlRbHAp/K5hKraF5HozQaPWMlzMAoc?=
 =?us-ascii?Q?hVhznsnrs2PhgQk9OyfH0Ic8iU/sLtqHWXjfK9u7NjZel30KVkpf5iZmCAOT?=
 =?us-ascii?Q?ui/l8i5KyBrZtARRp0gTQozHWZaQcN7FeH8LhPN4PHCk5kFs5HmLrA/ZDWdn?=
 =?us-ascii?Q?Xyb+FUrf26zWuu4JpJgr3KNoCq2KMaMJtPt3/7e/wr6lSZ0rcam5WI+iaR1J?=
 =?us-ascii?Q?LpexAWIhv2S8vkn+xClQIwlcI1xfx81j09kcb0nKpvszFO9sd3dwsoa4Bhi0?=
 =?us-ascii?Q?VINy+UW9a1X7wNQ5KgL0KtRSmQfjms8Typ/BNjhKGynLmKQ0wVwrlvcap+ww?=
 =?us-ascii?Q?fvgWZ5VK3HR76H76u1uvM0v8Rdip3IPAAThg//x1B0cPkuUIFp9ru77WJYY7?=
 =?us-ascii?Q?4cUWSnOWaKx8ybb8nkDgH3MxOJ0TNs0fKvuNqTNAag5bO8V4bcv0unIwYM70?=
 =?us-ascii?Q?IApMDZeTZ2ix5vvwn17EwBWzvAmdW+MCskeSvZcekrINZhauhsSLsJXwlAg?=
 =?us-ascii?Q?=3D?=
X-OriginatorOrg: sct-15-20-4755-11-msonline-outlook-746f3.templateTenant
X-MS-Exchange-CrossTenant-Network-Message-Id: c49a8dfb-4d55-431d-e622-08dc62cf8cf1
X-MS-Exchange-CrossTenant-AuthSource: ME3P282MB3166.AUSP282.PROD.OUTLOOK.COM
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-OriginalArrivalTime: 22 Apr 2024 13:24:34.5238
 (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: SY4P282MB4235
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: <https://www.postgresql.org/message-id/ME3P282MB31668D70A037A2189ABF2419B6122%40ME3P282MB3166.AUSP282.PROD.OUTLOOK.COM>
Precedence: bulk


On Sat, 20 Apr 2024 at 01:36, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Japin Li <japinli@hotmail.com> writes:
>> I see [1] has already implemented on login event trigger, why not implement
>> the logoff event trigger?
>
> What happens if the session crashes, or otherwise fails unexpectedly?
>

I am currently unsure how to handle such situations, but I believe it is not
only for logoff events.

>> Here is a problem with the regression test when using \c to create a new
>> session, because it might be running concurrently, which may lead to the
>> checking being unstable.
>
>> Any thoughts?
>
> Let's not go there at all.  I don't think there's enough field
> demand to justify dealing with this concept.
>

Thanks for your point out this for me.

--
Regards,
Japin Li