Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iFAfZ-0007Oo-99 for pgsql-committers@arkaria.postgresql.org; Tue, 01 Oct 2019 05:25:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iFAfX-00057z-OO for pgsql-committers@arkaria.postgresql.org; Tue, 01 Oct 2019 05:25:51 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iFAfX-00057d-EQ for pgsql-committers@lists.postgresql.org; Tue, 01 Oct 2019 05:25:51 +0000 Received: from out5-smtp.messagingengine.com ([66.111.4.29]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1iFAfV-0000iN-47 for pgsql-committers@lists.postgresql.org; Tue, 01 Oct 2019 05:25:50 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id D03E121F9F; Tue, 1 Oct 2019 01:25:47 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Tue, 01 Oct 2019 01:25:47 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm2; bh=2Re/2NX9szZIW9E8fgNBK0ETuN8 SKdO6ONesIUy7DF8=; b=lMot5XH+Q31LNI+jBJSaPKOGRow/byRuCnxBbUGw68T /tg5jDqwlJdbmVfxCiEbpjcG67MLzEMEzKFuE5qVB2Kes3nM/K9tD5rU1eZZ4LJa wzomayLSytkpSnYA07hVZnS3oT+I40GPafBft4QFILYE8SlmWUP6ozAzo7bgcBMG Fr9Fk7Fh/jAZTckeRiZskgKNXMl7/7zIxpLT0XfMVDvzeQR55sYvykWLGhY73M9b uWOuO18qKLXzgwIFLMo0SxtYBfKZbDQj/CH9ozPku0gGNhrCVgsh6O1fW9tX0eyh nwRNtJYy/EVGq5zg17oM+yzYDmA7yOsHFQxjrA9C8/Q== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm3; bh=2Re/2N X9szZIW9E8fgNBK0ETuN8SKdO6ONesIUy7DF8=; b=gJADByLrBP+JsvvPVZdSL7 DNfgckMzdopZbxMeELePxktRgDB0NqLtNgwKyJuuOkNggHEy17zlVh475QX+C84u MRHQMaaaomeX1bZUB1teiyKsNWaDLJzqnNu79XYewCXYJE1JEog0XTMbjuFRsGem wnyIG+pt1GZsT8ij1ZMOojfEvcT8tLccygYLUXk3U+xG93eIP1bVMYfECKVTzQUJ lLNxP20bGBBqWaPmUSI5ZrwaKxc2+9SSllMpWLaIAeGFpWLeOYoYP006w59sut51 xa9PyPO6cTxp3ILhuazu9lE9LG2j+GkT7VT27W6hjBvkRPYSq8UzzAACxnQN6PeQ == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedufedrgeefgdelfecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecufghrlhcuvffnffculdejtddmnecujfgurhepfffhvf fukfhfgggtuggjsehgtderredttddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhi vghruceomhhitghhrggvlhesphgrqhhuihgvrhdrgiihiieqnecukfhppeduudekrddvge durddvhedtrdefkeenucfrrghrrghmpehmrghilhhfrhhomhepmhhitghhrggvlhesphgr qhhuihgvrhdrgiihiienucevlhhushhtvghrufhiiigvpedt X-ME-Proxy: Received: from paquier.xyz (mp76f1fa26.ap.nuro.jp [118.241.250.38]) by mail.messagingengine.com (Postfix) with ESMTPA id 1091680061; Tue, 1 Oct 2019 01:25:45 -0400 (EDT) Date: Tue, 1 Oct 2019 14:25:43 +0900 From: Michael Paquier To: Tom Lane Cc: pgsql-committers@lists.postgresql.org Subject: Re: pgsql: Add hooks for session start and session end, take two Message-ID: <20191001052543.GI2781@paquier.xyz> References: <20191001045246.GF2781@paquier.xyz> <18722.1569906636@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="ELVYuRnMxQ5nnKRy" Content-Disposition: inline In-Reply-To: <18722.1569906636@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --ELVYuRnMxQ5nnKRy Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Tue, Oct 01, 2019 at 01:10:36AM -0400, Tom Lane wrote: > The idea that you can launch a query after proc_exit has started is > complete insanity. I hope this is just a poorly-thought-out test > case, and not something that's inherent to this module. If there > are not reasonable use-cases that don't need that, we should just > revert the feature altogether, because it's nothing but a large > caliber foot-gun. That was originally just part of the original test to prove the point of the session end hook where people wanted to be able to log some activity once the session is done with. -- Michael --ELVYuRnMxQ5nnKRy Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl2S41cACgkQnvQgOdby QH0d3w/7BxFlE6NTNQ1ghyvP+OBZblUqL+bYI+xjZAlDs/O+cyKxRbdCGH/bWvm7 2F02TljIYBqjJBgZzRfci9g8RvHpl5Bctb788tmeKHGcawMLdbxX1k94eVooL9SW 9ohoDpL0wc8en6h9qUsEZys8DGCvRvVH3lVygYdeYxNrX71DYACN0IoInO9YR3ml RYVoWA6HxBvX6RuGMpaZgctoR+blFTvcFNqTW2+D9QFg1zMSLxx91NBH/i1Pe9JS 0xf8ZC3fqgPgsVABgfQ+6zKTeo4vwtw1CgB+CbI76KPcCROoibCdB5lwFTl1MwFP 5d+U5ROpDZWSxrDGBg9oJqX4EK5RZyxBTTkGKR6BmzCBePZJEsTtHBATDoRVYc4l oJlRn+txH6o0C+yZ1is2oDSR3HoHWEBD5howwkRFbe7XJfXbotE/CgSO27gnu2hy Z3Y7n28+m/6a4UQtyutjLc39q2hJO89Jfq2Ck6x54RHSymwk0Ut2lw3X/Manjr8G Cw1Uy0RrXn5d8h6vPS6Nuhz8RHP3gui/qW9Ki2xae+bM+BUsVuQbYsflEnqt1q1x lo6NMy1gQ3jpRRiRX3qUk2Pd49fIHRVYeokBE2rfg7wwciDBwxwa/bIZGNaYW6/f AzqiJSxr2fzJfHFWicshersvplqRtkpI9UIJSK3ClFOwHr3sFw8= =0TVL -----END PGP SIGNATURE----- --ELVYuRnMxQ5nnKRy--