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 1wT0gY-000Ft5-2U for pgsql-hackers@arkaria.postgresql.org; Fri, 29 May 2026 17:07:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wT0gX-003i1Y-0p for pgsql-hackers@arkaria.postgresql.org; Fri, 29 May 2026 17:07:49 +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 1wT0gW-003i1P-36 for pgsql-hackers@lists.postgresql.org; Fri, 29 May 2026 17:07:49 +0000 Received: from mail-qv1-xf32.google.com ([2607:f8b0:4864:20::f32]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wT0gU-000000009Q9-1JJP for pgsql-hackers@postgresql.org; Fri, 29 May 2026 17:07:47 +0000 Received: by mail-qv1-xf32.google.com with SMTP id 6a1803df08f44-8cceaa6f75bso9981536d6.0 for ; Fri, 29 May 2026 10:07:46 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1780074466; cv=none; d=google.com; s=arc-20240605; b=WV2u/Y2cD3m3e6FpXR/sf0SvsLumR7fquAUkUsMSC3y5F0Kp3if9kR2uDpxGcxu7Cf GgNE8bSoeJwlOAck4ZgfDh2e26fI2C7WfkTN5ygWSG8pRrFALhS8lZZNsiBQVZeURQE4 m6cGZfWR/tzA+fRTPNrGW3EMLG2uLIRuyLfmyMMY/iVjb8iUTi77PZKXl13v+3q8XVTK oQn2WVNqxAFqG/bO2mSEMAiW4UiF+HgMHptGpvuMohR+YNroBX63PyYzTRCFzzO89NoG VydFTq42NtCchCskcSIFn+pBk8kpzdltZmxOZDuTe2C+rptrgd6dLA6D4SacIiL26oOp aorA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=RofdjybHNgq8q6HYXOQRZBXAoNJLYoh0FawXGolhHsQ=; fh=GB7TmI7M6Y28qT2ZDqtrTWnAHNonaFJx+hcppf1fpwA=; b=FuX/GQmrb0fBN75K/4cphIbScEJdyz+149tthHroFK8MW6TO4bgMeR5kjlGGrbh0Er T3fQUVhrEL6QpV7wPuay3p9urt1+KgZidfD2TjGjpCRSicNWYpWx7u9zouUgPg8pcHE6 8Q0HU0yB98DbnkrNbP8OJIF3swTOb08ZgmlJ9Ydb5vUOCa3+L8N8KR6muIyue3FUCv+7 Wc/If0zJOMUanYVcwDiPHzXYtsUIWLU6lu5STQgWMutQqau/cWr71Vv6D4JgE03F7EYa 4Yp9wkKBatsqFmmGxM2BmpPPT6D+xkfU9dDmEn6sayRD2gE4EztqOYadkhi/Dk6giCG7 QEsQ==; darn=postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; t=1780074466; x=1780679266; darn=postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=RofdjybHNgq8q6HYXOQRZBXAoNJLYoh0FawXGolhHsQ=; b=cN/u0UlqZKCBpg1tvb65MdkhO0y7zTg2GITnXBzEZDYAsk+Ee2s9nEoapnhNkaVdEu WItCAlMewrHSXITdMKP/RUxG220SFIpTNp5DYDMNXfHOFga2OviUx3cqZygyCOtwf4oG 7WjkcYKEbiIZFmKOFI2nAY4fAAMtmN6mrixjBVKbEGzoMg9qvu2jEJoB1+kAUFBKMl+1 Z1S/YfFHqXi0O3MZD1WrOTHKFBgsDxQtd4oon3p1rOW2nqVdpMa7quFea7LchzNxGV2a hQD+5xTAf5XXXPuJ3ZTpB+fCZfFMBg790gr2jvDgqwVpPnbb66bOwR3BBywQ0+K4fSnQ MmmA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1780074466; x=1780679266; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=RofdjybHNgq8q6HYXOQRZBXAoNJLYoh0FawXGolhHsQ=; b=nNcPn6khKu21tosi+3irh0Pcl/uTi7+eWeQAmEpuWUblO40ykLTYnQ1KxXQn6jnTAm uYZeT0thnQ1fDafI2+IEOME9ypnBldUvKCH27is3cKTHF2PDdI/P8jlA8y4cwm9F4wUL wOFpfbHqBScM6jiCgrLyB7SBA3ctWfqfFAJVDOdq96rKEyMgP2ZFv/pJBCV0oFeUwi77 vAzemFqusDPl74ilxLVz+5f72CB0h5wqzxodV8XwF8lFIFLcTmiwhYGMYpOKY0ucn2WD n0SpRxs2eS8eAJs7LTBp/Y8u3d5hvsnrgTluQNBYVtM9elhgfTXs56dkct8tz/FFMSRO sAoQ== X-Gm-Message-State: AOJu0YxwRTc2ESsbW5PPwYbcHNgHlRxkHdQFHnHKjN1Y7ew2Ber9MGpe hSdXfW+IcaaYC3BPwGfR5uI6uTFZ1IZhN5Gl1ufVmSOVqHjk2r8WdxxZcwGvBS6dGb9uCz0YmA0 fiNQYChUEPNlQ2ye3uv6lUWlXaitjrcPLQI2MsevFAAdbozoSNogopw== X-Gm-Gg: Acq92OHKYaoujDgYhsSA/PSh1z2OPz1Dr9Zx8Rz1dX8fxCWUyU/TwzeB8fE1NNc9oD/ bQEWcs6h2errNEgiF8k80tE2u9fqwRpvESdGG6bKLDPVDpSct3TE3LUUQMUuBZbD09DUGn/ycWF gFBbZi997k5mB0Yuz9RgWTsPjLozX+nN+7chiA6tEKAtVVeqD7YgjB0c27F5K8CKgNx6aPHg5dl /mzgJsC/hS9tlp61+0ZvlukExplcm4DQyVvzLjPaSBVV89cz/qR/L8xl8nV6rCLqztMn078CE1b ke56sk9qQ7Cx58giNwWl X-Received: by 2002:a05:6214:598d:b0:8a5:104b:e37b with SMTP id 6a1803df08f44-8ccefde099bmr9941716d6.42.1780074465821; Fri, 29 May 2026 10:07:45 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Jacob Champion Date: Fri, 29 May 2026 10:07:34 -0700 X-Gm-Features: AVHnY4KbUoJfiZZ9QLh7-bbStHK7u_cDfvCx2Ej6Q60EwjiYwPXQzrYzduZNHUI Message-ID: Subject: Re: alert clients when prepared statements are deallocated To: Nathan Bossart Cc: pgsql-hackers@postgresql.org Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, May 29, 2026 at 9:33=E2=80=AFAM Nathan Bossart wrote: > > I'm certainly open to other ideas, but I'm afraid this is the best I've > > come up with in my admittedly limited time thinking about the problem. Grab bag of alternatives from the other thread: - let drivers pin protocol-level prepared statements so that application-level DISCARD doesn't touch them - explicitly separate client and middleware contexts or streams from each o= ther - rebuild discarded prepared statements opportunistically on a failure --Jacob