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 <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1wUmjJ-001RYn-1A
	for pgsql-hackers@arkaria.postgresql.org;
	Wed, 03 Jun 2026 14:38:01 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.96)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1wUmjI-001sFz-0z
	for pgsql-hackers@arkaria.postgresql.org;
	Wed, 03 Jun 2026 14:38:00 +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 <nathandbossart@gmail.com>)
	id 1wUmjI-001sFn-05
	for pgsql-hackers@lists.postgresql.org;
	Wed, 03 Jun 2026 14:38:00 +0000
Received: from mail-ot1-x336.google.com ([2607:f8b0:4864:20::336])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.98.2)
	(envelope-from <nathandbossart@gmail.com>)
	id 1wUmjG-00000000vGu-1yqp
	for pgsql-hackers@lists.postgresql.org;
	Wed, 03 Jun 2026 14:37:59 +0000
Received: by mail-ot1-x336.google.com with SMTP id
 46e09a7af769-7e6deacafa8so439146a34.0
        for <pgsql-hackers@lists.postgresql.org>;
 Wed, 03 Jun 2026 07:37:58 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20251104; t=1780497477; x=1781102277;
 darn=lists.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=wOmjs2tUXLkV38KR/zLNq5IHupmsmsumYle5rOs8IY0=;
        b=YIwQI0UYDGG7B8wEbiWMLvoTS+uELjbPk7Ekydk62P7jpY8voeZGzMmO8epjTruLYc
         xNEvMl3srrmIVqi6tc9Ak8MoJskBU65BUUznJhlZOqxLnFjCG1i5BA9pxlbat8pJfJh1
         HP+Yp5VIcUSqLlTWMpZIUV3T3TEOrgwS6048ygidXy9AEh5pgRx1BRWaQOjv4795zEBw
         VvfpZmdSfuIT69DtLN0ROyGw9rAM46irEan8A5wn8GM1bzuB6ZSKeSqrHP2MhFkJXKnf
         IbKjBZDHlsp0/kWXg3Of5+j2qVkt3WwA5LcN8+BTuQIlE/8rt2DMeiZ0wuAM3e7Q2niR
         W78A==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20251104; t=1780497477; x=1781102277;
        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=wOmjs2tUXLkV38KR/zLNq5IHupmsmsumYle5rOs8IY0=;
        b=cym7mmAJNmz1dgVmEtLKMO77MXL8r9UVvdEI77k//e5qdElmFxjTDXIj+iHdSXmAxI
         j6d+C2slabQUaJCmrS6f0fU1B1dAzHerEnmy8Qt7RZIADdX7S60vsOAKvTHdwP36062U
         SDZdtD91x0Wz9NT8i5fre6T261cUFagP+9DsaqA7FbtdLVvJ9sUPTXj2dftvCxN4lcWu
         WX7Ccxg+McAIwyU6C7uNPrC0dkv9xBXlMumE5zPbey+EAyddHZaKGEKwXqzNp5AvC73k
         hZhOfQdwFGhxk0N8MI6PyCvQ8rd5ZtcFhMxPwZCLlxm9QMj3jwIGz/lYeiEDxhiBm8uJ
         V0wA==
X-Gm-Message-State: AOJu0Yx9qkrfwD1LVBUlnzVhYPYXLCuI83oH36XFOmPlSOc89NfUdRcP
	0P+fVCcqHp91H4K/4K2lz4RYPKXc2Bij+UKWFQmRjlNICd5TOKUzlVX5
X-Gm-Gg: Acq92OEvESksXUrSLBFsowB/4HQhyn3g7UGqZAn+lahmS/XItI7IJNJ6Ft7ZT5k/40g
	pR7xcDGqhgESE6MGmmfwBxSnRGK7YvIDkZWwCp5sz6K4rcV3ttjflTu1IW/R80IM9HCwnapeUTZ
	/n1PdboAG8n1Sw18XbS8B524xkNq9+VZislFdApoI2bmFnavMpZH4mLuWQkUOIjJKLVDrM3Ay7l
	5B5mPFLnC8D+kcNVaQV299NoKieTksDzlPMNE/I4F+W9xDURbY6qkF46p0/SdPPk2PJMZ6Ikobd
	TxMeMxd0ptjKcJolmLhyxkXYU9WLBiEoA9tpiWTDakPTLT0Ce9rY7hcb9Mk+ylBimUIG57uUBb7
	Keuzd2mpE2PnZ93tF8TPnNDR4152NJNBxzSgOOy3c6bTEFLjpAbp3YLvxsSb3wbP6BZH/63ZLxw
	buSXGH7vD9VzNBiOi0MYJxp/VWhZSJRFX/P09qNCuAbLe+fbcJ1jyrW1dvNJcNnyLD6tDgrtKJ8
	kTzpquqxz7GhNUL/dLY0rCu/K5b6MbmPtNBoulH9dc=
X-Received: by 2002:a05:6820:339a:10b0:69e:4cb9:4a67 with SMTP id
 006d021491bc7-69e4cb95112mr747645eaf.26.1780497476878;
        Wed, 03 Jun 2026 07:37:56 -0700 (PDT)
Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net.
 [162.195.168.172])
        by smtp.gmail.com with ESMTPSA id
 586e51a60fabf-440d8297311sm2576996fac.12.2026.06.03.07.37.56
        (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256);
        Wed, 03 Jun 2026 07:37:56 -0700 (PDT)
Date: Wed, 3 Jun 2026 09:37:54 -0500
From: Nathan Bossart <nathandbossart@gmail.com>
To: Zsolt Parragi <zsolt.parragi@percona.com>
Cc: pgsql-hackers@lists.postgresql.org
Subject: Re: alert clients when prepared statements are deallocated
Message-ID: <aiA8QjUaeECCL-pt@nathan>
References: <ahm_4eOKkkKJ3Gds@nathan>
 <1689313.1780074543@sss.pgh.pa.us>
 <ahna7lre-xAn7DIS@nathan>
 <ah9VKGwwlgqF-hi7@nathan>
 <CAN4CZFP5HL9Gf_-AnFN+w7MbMCNNnzN=3u-_+rk-G-JUiEzLZA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <CAN4CZFP5HL9Gf_-AnFN+w7MbMCNNnzN=3u-_+rk-G-JUiEzLZA@mail.gmail.com>
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/aiA8QjUaeECCL-pt%40nathan>
Precedence: bulk

On Wed, Jun 03, 2026 at 07:14:53AM -0700, Zsolt Parragi wrote:
> DropAllPreparedStatements has an early return if prepared_queries is
> uninitialized, so we don't send anything in that case - but it calls
> SendStmtDeallocMsg if it is initialized even when no nothing was
> removed. This seems inconsistent to me, is it intentional?

Nope, will fix.

-- 
nathan