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.96) (envelope-from ) id 1wUqoa-001UWj-3A for pgsql-hackers@arkaria.postgresql.org; Wed, 03 Jun 2026 18:59:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wUqoZ-002zsy-2W for pgsql-hackers@arkaria.postgresql.org; Wed, 03 Jun 2026 18:59:43 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wUqoZ-002zsp-0m for pgsql-hackers@lists.postgresql.org; Wed, 03 Jun 2026 18:59:43 +0000 Received: from mail-ot1-x32f.google.com ([2607:f8b0:4864:20::32f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wUqoV-00000000xH3-49aK for pgsql-hackers@postgresql.org; Wed, 03 Jun 2026 18:59:42 +0000 Received: by mail-ot1-x32f.google.com with SMTP id 46e09a7af769-7e6b573491eso2398479a34.1 for ; Wed, 03 Jun 2026 11:59:39 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1780513179; x=1781117979; darn=postgresql.org; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=u59EfuCGnsZPyQmxXrLK8nZdh9jlWypgjDOGA3JVny4=; b=LxaVYE4A8B+lJbauK/eJ4gMwb2TgQxyFjpcH4ieEy2/hFFHLue47kp9mP8ONOUXY5T dwYKBLBu0J+EL2vx0cIW58wWAjJQ5c52OaMsj8iAEymExVMtTN7GmQqxPrDpsLv2Crlr ZbwLaRLONGqHv1d3MZ3vTPuh7G0pyhBjscJEdhQ1q+Wol5BXZNMbDPno4Z6B57WvTsqe enbkPUuNL/YGOcWo+HfWfanFqM4gz2d2QtdUFyAbCYDuG5TTl0lUWaubGLkc0eCZN5XE BDIgwPSYjcWImnWfdcjDeraGM1Nhkr9i4+exUnt2TyIQlQYrydbxsbPBsm/0iLXFiKVS LD8w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1780513179; x=1781117979; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-gg:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=u59EfuCGnsZPyQmxXrLK8nZdh9jlWypgjDOGA3JVny4=; b=XUratgi0Y0lNUfzoSslD5GDhAdkovm0SCjZxK2Fn73ck8AGCtn9cdA2ledHLgcE7Kk fRLDbyA+JxeTXtVx4bXsP5kPLZOvYGviq8aNvMGs+7TzYwNkY3UaS7qMcJGnFPCaupsV FoDGM7l4dD4t2fI6IfvU+BsHoms2VF/SdL7zBZ1rWhZeej7rEOZWKjWptBmQ79o/Km++ jhuLPBYltWilylUEF+eb3P2yj1IG+g1vZAuK+PJWcGYzaO3YAYbZuo/yWfT3zZfXyaxJ TFqbTixB6aKE5Gf5bnLwL+E7hNNcW+IOmX6kH8S0h3sYq2kSRjzyLlrlti1hjNxWWvo3 VDUQ== X-Forwarded-Encrypted: i=1; AFNElJ/IvdWFMg4YyvYIrBVBqJexflToT21BQ08LFz7YxexNXvX9jfQIPhL+OYC123sfsx00124Gy3ScTM7+jJJg@postgresql.org X-Gm-Message-State: AOJu0YygBExAxrGe1r4A6VU2ZGCrDhpZCSmQGiIW9PumljQL59UDXgef 1ziBplO1isMfHEVPiWVgJKlfML2cqp4r3AB7/vqwmhbZo5eIRVRHpiLm X-Gm-Gg: Acq92OG0oNb+RlmVeNwE9rKKjGrhbrDoCykkfTh/H9N1ibTgyxwe8ONX5A/IfGc7i/K c+1yeVzu+YY95AYnMq3XOwTL4DvHjnVrfPcI2FQnhgat8p0XwFpfvMtLDfNYnBXxu0qKQ2KEdzj YyAA2ULTAoI4vpdDWvc7o8eB3P2Md/th6+KJevZQYFfZtG826UEPJhfCEsjTGUE+JtVKgis5b4z Oll2Im/fncv+lM0ImJl5gxoYEXrIK4vKy5QN78AijeOFet1ecZxUMCjoRebiIGw250vbUBttnwn xq/Jk+N9x/lqfXNC0H81ErCu+9XQQ2GeGA/hChGMleuDcGwfpaSLhieLbWLmQMz17M+GZ4sJHXI ApNMzGW0AYzP6/YPo4CqhQbVJGFg5RI0MqFBcbX6+51Ojum1V+nYQyQ8oRchhDGL9EpxDkpkRZo wVck68rw8kb1/5i9enICL9venjklyEmIrJlf3tSOZB+okOrfmKFCWKn+2yPHbt8rxAF09rwOJM5 jT/M204XxY3r7VN8HeMAntSF08Jstl3F/yIlTPruIs= X-Received: by 2002:a05:6808:6909:b0:485:3d0f:22c with SMTP id 5614622812f47-4865a935e95mr2906507b6e.7.1780513179160; Wed, 03 Jun 2026 11:59:39 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 46e09a7af769-7e6e75ef0e4sm2324360a34.12.2026.06.03.11.59.38 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 03 Jun 2026 11:59:38 -0700 (PDT) Date: Wed, 3 Jun 2026 13:59:37 -0500 From: Nathan Bossart To: Tom Lane Cc: Jacob Champion , pgsql-hackers@postgresql.org Subject: Re: alert clients when prepared statements are deallocated Message-ID: References: <1689313.1780074543@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="qzBwIkMoeP65cCz/" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --qzBwIkMoeP65cCz/ Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Here is a new version of the patch that adds a connection parameter for disabling it in libpq. I've also done a round of cleanup and added a first draft of a real commit message. -- nathan --qzBwIkMoeP65cCz/ Content-Type: text/plain; charset=us-ascii Content-Disposition: attachment; filename=v4-0001-Alert-client-when-prepared-statements-are-dealloc.patch