Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qGpcH-0005Rr-Fd for pgsql-hackers@arkaria.postgresql.org; Tue, 04 Jul 2023 23:39:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qGpcF-0004hH-TH for pgsql-hackers@arkaria.postgresql.org; Tue, 04 Jul 2023 23:39:27 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qGpcF-0004h7-K2 for pgsql-hackers@lists.postgresql.org; Tue, 04 Jul 2023 23:39:27 +0000 Received: from out3-smtp.messagingengine.com ([66.111.4.27]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qGpcD-0024Jh-BS for pgsql-hackers@postgresql.org; Tue, 04 Jul 2023 23:39:26 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.46]) by mailout.nyi.internal (Postfix) with ESMTP id D44A05C026E; Tue, 4 Jul 2023 19:39:23 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute2.internal (MEProxy); Tue, 04 Jul 2023 19:39:23 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:sender :subject:subject:to:to; s=fm2; t=1688513963; x=1688600363; bh=1S 7N+IM6j0USqJ+GDdV7UPYLItUdGVJjU80vCRw+OwI=; b=DmHFlbrAkzUxJfYnGK D7S/t9eUmv9LTxPRnnjaMIKRlCbZRniGt2oI50NqnbwwOfndicP4fH0UvaIssov2 owcC07utV1P/HMqV6jWlsS9GkgZjxOWVMe99ZbM+rEBa2JDlq/3rbqsOMP8VBkHh dvdR1vvsTswq/1vmidcfRtDRETcJGh6Ideu4DDq3bF053X3+/95tpwyAWAKvrG32 fIm8my/SiC/kS21i+eqNc72830O2mwA8JIi4huMt59pWI9eVsS1IWXrBjUYKCui2 pZltDfOQ5K6Q9V+E7QTqzJ9Y/TLeIadsJ3tHG5rIQAYpe0ydOW0DhskCgSLe8y2W NT2Q== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:sender:subject :subject:to:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm2; t=1688513963; x=1688600363; bh=1S7N+IM6j0USq J+GDdV7UPYLItUdGVJjU80vCRw+OwI=; b=JqYtR/68wMVaVQAvd2knDWiCD+HVX Ud7KBFsgU4F7O8sBjbvVkrEvaqgoqn2hb0WoFbgGE4/AnhTdHf1m4zyzzQ9wCNAd tKAYVkjZTSSsP1FWPBCGAEqRKSylZTYgPaYB2wcRrFdbgQXKrYFo2PykZINLzzQA OTse8DC2/vdblyrOuHPZJQ4YBQ/QUOrh1DJLtVI+Mt5mHExHc+SW+6m7nDAhXJc8 jYPULECERoTTFhX66EHDbysJ7ZuRzmIuNbxnsVhrXXYOoTKuGtv/24MvEA6AKpGj R/UPSLSTaSxvRTYuQAnh6REtf0rIwoHLKK8Oc4y4bpQB7zr0YlWPdqtqg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedviedrudehgddvgecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfg hrlhcuvffnffculdejtddmnecujfgurhepfffhvfevuffkfhggtggujgesghdtreertddt vdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprg hquhhivghrrdighiiiqeenucggtffrrghtthgvrhhnpeetleeifedufffhhfdtteelgeeg geffhfekueevteeigfduudevudetgfegiedvjeenucevlhhushhtvghrufhiiigvpedtne curfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdighiii X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 4 Jul 2023 19:39:21 -0400 (EDT) Date: Wed, 5 Jul 2023 08:39:19 +0900 From: Michael Paquier To: Jelte Fennema Cc: jian he , Dmitry Igrishin , PostgreSQL Hackers , Daniele Varrazzo Subject: Re: Deleting prepared statements from libpq. Message-ID: References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="PLYtriB8FEJ4BTbq" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --PLYtriB8FEJ4BTbq Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Tue, Jul 04, 2023 at 04:09:43PM +0900, Michael Paquier wrote: > On Tue, Jul 04, 2023 at 08:28:40AM +0900, Michael Paquier wrote: >> Sure, feel free. I was planning to look at and play more with it. > > Well, done. For the sake of completeness, as I forgot to send my notes. + if (PQsendClosePrepared(conn, "select_one") != 1) + pg_fatal("PQsendClosePortal failed: %s", PQerrorMessage(conn)); There was a small copy-pasto here. -- Michael --PLYtriB8FEJ4BTbq Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmSkracACgkQnvQgOdby QH20ihAAqi53AsJIV3gJe6qGt6QSy+rZiYHRn84K0Vn73HCbKa+v0Mj0V8tdL524 3GEB/0WD/R2EVTEGA8PkIo8913jJXx/+h9DKkGMcR3fBQ4UnB8urRQQoapZGZQbP 2X1zxHgijSQZl5BRoThEEC48FufWc4vqNs2PDbMhEeyFy1QFzkECUwOgqjpTARP7 WnSQw5balAwrywfL/+Tos/LLvAcxYJJGLF9vU459LAPgqrw/lUoBWXxoupkeK2F3 7DOiXfuIiIpfy3Y6o1O0t3+aKdodZCJRQ/MU7yIQwRK3bBq9zzBWLjfIwIhnuyDb E9LJucRL7TTQQuQ/3I/sUW6VVFz+iTrMWAD4xKvuTbYD1gfE338YGci67chJK+BQ HwW7pqLdqY7V0zmtbF8xsN/urZdL8LtnAA53AWk3cTofzqkRcKkoHOL5KGRE0VuG IfpS01HY2l6Lr1s0YKR8oEzyDxqVdobuE+O3BQTdjyd9/PDTFzeP/s9x9WWIu36Z L5Uu13Hhgq9sRBfmAcSQGKwOwX+7y0XQg9UD2BfNm+GV1Sd0DvodS32+1FC6BQCS PGIOqpoqqxEsM/HX/2Q+154+188HPXvT5AB0CclGvKKgJ9eiV0+YnH6e4rTbHRJM lLTnNoyN2PTiKonQHeWjlmgrG/a4L6lcuarw2bae/SnPZ+DFJ7M= =pc6j -----END PGP SIGNATURE----- --PLYtriB8FEJ4BTbq--