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 1wS2TF-002uFL-2e for pgsql-bugs@arkaria.postgresql.org; Wed, 27 May 2026 00:50:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wS2TD-006adX-2d for pgsql-bugs@arkaria.postgresql.org; Wed, 27 May 2026 00:50:04 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wS2TD-006adP-1p for pgsql-bugs@lists.postgresql.org; Wed, 27 May 2026 00:50:04 +0000 Received: from fhigh-a3-smtp.messagingengine.com ([103.168.172.154]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wS2TC-00000001bq5-1l6u for pgsql-bugs@lists.postgresql.org; Wed, 27 May 2026 00:50:04 +0000 Received: from phl-compute-02.internal (phl-compute-02.internal [10.202.2.42]) by mailfhigh.phl.internal (Postfix) with ESMTP id 086EC1400093; Tue, 26 May 2026 20:50:01 -0400 (EDT) Received: from phl-frontend-03 ([10.202.2.162]) by phl-compute-02.internal (MEProxy); Tue, 26 May 2026 20:50:01 -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:subject :subject:to:to; s=fm3; t=1779843001; x=1779929401; bh=vQhatDGS1o sUyHmi557SxBo6K1nSb3CDFCMBAbRn8y4=; b=Ddu30raeJsNCROD5NxvJcmwteL /omqer+M/wGKWUCtrV93J6dmcr2dNYVu+g8oJomzlwJul7Dc4RS8ahg4IgtaW2VJ EvsBGcOh+30bpH7kOMzbO3koDxESyxfc1ThsmyE93WHu/s0frcEdLCWwPIGpNSN1 O16Chid21LD9BBt8PYs/GA70FMGTtwh2bFd7tR07haxuukNWLsYsBAuoocXtl+5W lbqpfd+V9rV3z5bsLvFmSBv2gWt59B8L93moC5MhjdFva6MoiAJ55OfbP5d+B1OF KC7dG+T3fH/MjrXEK/EJxG6o8ORJD5/H41FNB+msaijiZi5czquXCdtDhdKA== 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:subject:subject:to :to:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm3; t= 1779843001; x=1779929401; bh=vQhatDGS1osUyHmi557SxBo6K1nSb3CDFCM BAbRn8y4=; b=vfU9hZjxJc9mKCsHbkjC6mm682nqq4p7uhp75Vz3Es1HSzjZT25 YLS+fFer2G2b5MpAkkcI6LD+EKVoRcvZZIF4Ioauf/mb33Y819cvcQEwlECrEqsN OaMb1rpWZBk+t/DbOfKCb6HxFMCqt/HNABkf3E+8WcrTgs8iYolD3ZJTv3YIqakG D8Ew5RkD99iCr+RjN2o11ZBob6wWX3cORyvSwHqQpIHnIVB64fUpH6XtU0UdJpFe XWkBvA2P3r1QwopKhjGRVBE5oZ6tmvPydZn8CAmaIqXSAtXAAR32t9KfVlEeTXLd g6vAI9nj4vetzCqD5e+cOMGyWC40J0sy9Uw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: dmFkZTGdhh+JVbcoAu3+pP8jQtSMf2YaQPYZctZDn5IwXbcwEjrrfH4G5EzyYz8lL9qo9A dhjgEJWl3lTUUWp/sl4kPTBrWDSjrZmrkC17uOC6bIMdWPqeITiFlm4iF8yxCHvypotGjr 56hyra5gQkkK4/8+Md2yuJYRpWzk0ub+P/+OH+1AYYB8AUW8YiDHLlLcoCLbH+h0Sgonpi Pvu3IetlygkEB26Fa3XbrUTqseNSfOMaX3NOTOrn+yCMdt6RDzKPo0/WdUZ1haRxgRuuqr 36HomCptslmpzNtO7Wd6XnaQbJduEKA059K997VA52Djkown0XW5s/yCGAc9dmnQld01Gt Z/fStTDvPn3ybkQ6uhOyu6oevJbQ0UX4gpjDJOavHLgBbAt5/yU9a1Z5XvTAdhnf4l7QRi TjwhVc+15fXgIttrJSRpXh3gVzaG1mE4iyiEvKfbxsfnHM+tVO9slbrVNfwadbPv9EsWKt Irr+Q58GGWYheQBEuo7pjrKshjQh/+1LRGZCwfXgmPO9UlLN469frgHET0kOz6xcNrCyd1 WcxNdXLUs9r6y6yuYPZymR7JlVUUfT/6OVGHul3mTKOyxEwGVHJ4dQMUg4zmKTip54WJi6 f+m0LjTc6Q7ULADWKW8kcY7J7mEoNqtok7orqFq766fnA1l4VWAtViJ7Nltw X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 26 May 2026 20:49:59 -0400 (EDT) Date: Wed, 27 May 2026 09:49:55 +0900 From: Michael Paquier To: Pierre Forstmann Cc: n.kalinin@postgrespro.ru, pgsql-bugs@lists.postgresql.org, PG Bug reporting form Subject: Re: BUG #19493: Assertion failure in pg_plan_advice with EXISTS subquery and DO_NOT_SCAN advice Message-ID: References: <19493-5878eac7a2525c23@postgresql.org> <2d59d7d6-6afe-4565-8ff7-ae764651589a@gmail.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="jTbV+iI3xIXMI/mn" Content-Disposition: inline In-Reply-To: <2d59d7d6-6afe-4565-8ff7-ae764651589a@gmail.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --jTbV+iI3xIXMI/mn Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Tue, May 26, 2026 at 07:52:03PM +0200, Pierre Forstmann wrote: > I am not sure pg_plan_advice is supported with PG 18.4 ? Nope, the module is not supported on 18.4. > I cannot reproduce with latest commit from PG 19 master branch: But if you can find a problem while testing the module only on HEAD, that would be a bug we would need to take care of. -- Michael --jTbV+iI3xIXMI/mn Content-Type: application/pgp-signature; name=signature.asc -----BEGIN PGP SIGNATURE----- iQIzBAEBCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmoWP7MACgkQnvQgOdby QH2NCQ/8DuwaiM57ExPjesqObZYbVeNkJbwp/C9hWgr5m5yYcNz8DwOIvLPSOQ33 +esPIkdJpJAwQsEc1buBWBOm+NKsMNDB+/KyMwr96Hv0+WVewkHhelfOg+dQOcQR c5oASzjkzsbNrLhyX60j019HRyo3F1LU2espZLzKE2HjsJ5iMQ0Qfl23xAGXKPYw t58g6flfcD1MMo+u/Wdu703isRyQrPn4bbKSB1VTVmBSYUWpK75CP13eOeDdBhnM 7rCCwx0L8um+cJmwrD0rgcd55sjQapci2Pw19lQtflZHdNL3vjToy2En5s8HIyq1 Q3JcnliQPpSl7XqQarkrDQdxNDS7G0BG3nkptUo3CSHl/v8rSDw22oKQMgNQ+x7e 8wPYy7fb99qP3OdO2A2qkKsjuQGUjoQhBK9IVQxWNKuar2kJTRW0PFfyNQgyIdgq pSJOf1L8bd+UxL/nUoyZTCN8df2HI3Lp/kwDEGhObqDzmDSr3L5B67PSkyfQ1oMF GqCN056AG7AQ+uzqarNVbRhZcx4FmSBCf5HbXksYRHbmbv7OrPxCjZw0BF7a/zHU KETiBBTDnfjIu5LprdBwK363aSpyy9i9TF2QU3c7Qc/lBJeYu1F6a2GE/P8zHBqw dUd92iXVb0jMvsAK0gpt6l/Z1kSFYXBMuOjpRgJLsxKvTSNUYK0= =nSGe -----END PGP SIGNATURE----- --jTbV+iI3xIXMI/mn--