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.94.2) (envelope-from ) id 1rvBxb-00AKk3-Ph for pgsql-committers@arkaria.postgresql.org; Fri, 12 Apr 2024 08:08:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rvBxa-00BPXm-H5 for pgsql-committers@arkaria.postgresql.org; Fri, 12 Apr 2024 08:08:34 +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.94.2) (envelope-from ) id 1rvBxa-00BPXc-2r for pgsql-committers@lists.postgresql.org; Fri, 12 Apr 2024 08:08:34 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rvBxT-000VpJ-Pa for pgsql-committers@lists.postgresql.org; Fri, 12 Apr 2024 08:08:31 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=jAqQUeZ1LOCeDdfbkeliKpLUSnRf1qmMT28XmGsqu8s=; b=yplJoPhkms6yA9t2xIcq6WElMC JOpmw5Gijp700mosSNB0D8kRJyfOfOz6vwaWV0Pm1HtTFiMYo4G4rNZcsjW0MGDVcFHEKHwZML8HF iIfoKt6r2mT6U9Ik0rFTsU81l/QP0PM66KMgEIUMoicQZ38mPKdlXJHC5RyJPnCARrQVDIs8lQyip rw0t174JDBlT1hkzHxh4LghMA85WVQMChLgMZskmb+HkYNedEhPwaBkLw6WT7xMPk8rwhD1goasat s38M/sxs1Xg6wIG54kWRim4jkyIIqIZ+r31cW6HgmiW7XQgCd1y16IKvX/NyOffR6xFm/rXPcMYah jLUyPwww==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rvBxR-005VIh-Ry for pgsql-committers@lists.postgresql.org; Fri, 12 Apr 2024 08:08:26 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rvBxQ-001i5n-8l for pgsql-committers@lists.postgresql.org; Fri, 12 Apr 2024 08:08:24 +0000 Content-Type: multipart/mixed; boundary="===============7333293368642956537==" MIME-Version: 1.0 From: David Rowley To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix IS [NOT] NULL qual optimization for inheritance tables X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 12 Apr 2024 08:08:24 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7333293368642956537== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IElTIFtOT1RdIE5VTEwgcXVhbCBvcHRpbWl6YXRpb24gZm9yIGluaGVyaXRhbmNlIHRhYmxl cwoKYjI2MmFkNDQwIGFkZGVkIGNvZGUgdG8gaGF2ZSB0aGUgcGxhbm5lciByZW1vdmUgcmVkdW5k YW50IElTIE5PVCBOVUxMCnF1YWxzIGFuZCBlbGltaW5hdGUgbmVlZGxlc3Mgc2NhbnMgZm9yIElT IE5VTEwgcXVhbHMgb24gdGFibGVzIHdoZXJlIHRoZQpxdWFsJ3MgY29sdW1uIGhhcyBhIE5PVCBO VUxMIGNvbnN0cmFpbnQuCgpUaGF0IGNvbW1pdCBmYWlsZWQgdG8gY29uc2lkZXIgdGhhdCBhbiBp bmhlcml0YW5jZSBwYXJlbnQgdGFibGUgY291bGQKaGF2ZSBkaWZmZXJpbmcgTk9UIE5VTEwgY29u c3RyYWludHMgYmV0d2VlbiB0aGUgcGFyZW50IGFuZCB0aGUgY2hpbGQuClRoaXMgY2F1c2VkIGlz c3VlcyBhcyBpZiB3ZSBlbGltaW5hdGVkIGEgcXVhbCBvbiB0aGUgcGFyZW50LCB3aGVuCmFwcGx5 aW5nIHRoZSBxdWFscyB0byBjaGlsZCB0YWJsZXMgaW4gYXBwbHlfY2hpbGRfYmFzZXF1YWxzKCks IHRoZSBxdWFsCm1pZ2h0IG5vdCBoYXZlIGJlZW4gYWRkZWQgdG8gdGhlIHBhcmVudCdzIGJhc2Vy ZXN0cmljdGluZm8uCgpIZXJlIHdlIGZpeCB0aGlzIGJ5IG5vdCBhcHBseWluZyB0aGUgb3B0aW1p emF0aW9uIHRvIHJlbW92ZSByZWR1bmRhbnQKcXVhbHMgdG8gUmVsT3B0SW5mb3MgYmVsb25naW5n IHRvIGluaGVyaXRhbmNlIHBhcmVudHMgYW5kIGFwcGx5aW5nIHRoZQpvcHRpbWl6YXRpb24gYWdh aW4gaW4gYXBwbHlfY2hpbGRfYmFzZXF1YWxzKCkuICBFZmZlY3RpdmVseSwgdGhpcyBtZWFucwp0 aGF0IHRoZSBwYXJlbnQgYW5kIGNoaWxkIGFyZSBjb25zaWRlcmVkIGluZGVwZW5kZW50bHkgYXMg dGhlIHBhcmVudCBoYXMKYm90aCBhbiBpbmg9dHJ1ZSBhbmQgaW5oPWZhbHNlIFJURSBhbmQgd2Ug c3RpbGwgYXBwbHkgdGhlIG9wdGltaXphdGlvbgp0byB0aGUgUmVsT3B0SW5mbyBjb3JyZXNwb25k aW5nIHRvIHRoZSBpbmg9ZmFsc2UgUlRFLgoKV2UncmUgYWJsZSB0byBzdGlsbCBhcHBseSB0aGUg b3B0aW1pemF0aW9uIGluIGFkZF9iYXNlX2NsYXVzZV90b19yZWwoKQpmb3IgcGFydGl0aW9uZWQg dGFibGVzIGFzIHRoZSBOVUxMYWJpbGl0eSBvZiBwYXJ0aXRpb25zIG11c3QgbWF0Y2ggdGhhdApv ZiB0aGVpciBwYXJlbnQuICBBbmQsIGlmIHdlIGV2ZXIgZXhwYW5kIHJlc3RyaWN0aW9uX2lzX2Fs d2F5c19mYWxzZSgpCmFuZCByZXN0cmljdGlvbl9pc19hbHdheXNfdHJ1ZSgpIHRvIGhhbmRsZSBw YXJ0aXRpb24gY29uc3RyYWludHMgdGhlbiB3ZQpjYW4gYXBwbHkgdGhlIHNhbWUgbG9naWMgYXMs IGV2ZW4gaW4gbXVsdGktbGV2ZWwgcGFydGl0aW9uZWQgdGFibGVzLAp0aGVyZSdzIG5vIHdheSB0 byByb3V0ZSB2YWx1ZXMgdG8gYSBwYXJ0aXRpb24gd2hlbiB0aGUgcXVhbCBkb2VzIG5vdAptYXRj aCB0aGUgcGFydGl0aW9uIHF1YWwgb2YgdGhlIHBhcnRpdGlvbmVkIHRhYmxlJ3MgcGFyZW50IHBh cnRpdGlvbi4KVGhlIHNhbWUgaXMgdHJ1ZSBmb3IgQ0hFQ0sgY29uc3RyYWludHMgYXMgdGhvc2Ug bXVzdCBhbHNvIG1hdGNoIGJldHdlZW4KYXJlbnQgcGFydGl0aW9uZWQgdGFibGVzIGFuZCB0aGVp ciBwYXJ0aXRpb25zLgoKQXV0aG9yOiBSaWNoYXJkIEd1bywgRGF2aWQgUm93bGV5CkRpc2N1c3Np b246IGh0dHBzOi8vcG9zdGdyLmVzL20vQ0FNYldzNDkzMGdRU1ptalI3YUFOekVhcGR5NjFnQ2c2 ejhkVC1rQUVZRDBzWVdLUGRRQG1haWwuZ21haWwuY29tCgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoK RGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYv M2FmNzA0MDk4NWI2ZGY1MDRhNzJjZDMwN2FhZDVkNjlhYzVmNTM4NAoKTW9kaWZpZWQgRmlsZXMK LS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvb3B0aW1pemVyL3BsYW4vaW5pdHNwbGFuLmMgIHwg NjAgKysrKysrKysrKysrKysrKysrKysrKy0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL29wdGltaXpl ci91dGlsL2luaGVyaXQuYyAgICB8IDMzICsrKysrKysrKysrKy0tLS0tLQpzcmMvYmFja2VuZC9v cHRpbWl6ZXIvdXRpbC9wbGFuY2F0LmMgICAgfCAzNyArKysrKysrKysrKysrLS0tLS0tLQpzcmMv YmFja2VuZC9vcHRpbWl6ZXIvdXRpbC9yZWxub2RlLmMgICAgfCAyNSArKysrKysrKystLS0tLQpz cmMvaW5jbHVkZS9ub2Rlcy9wYXRobm9kZXMuaCAgICAgICAgICAgfCAgNiArKystCnNyYy90ZXN0 L3JlZ3Jlc3MvZXhwZWN0ZWQvcHJlZGljYXRlLm91dCB8IDQ4ICsrKysrKysrKysrKysrKysrKysr KysrKysrCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL3ByZWRpY2F0ZS5zcWwgICAgICB8IDI3ICsrKysr KysrKysrKysrKwo3IGZpbGVzIGNoYW5nZWQsIDE4MiBpbnNlcnRpb25zKCspLCA1NCBkZWxldGlv bnMoLSkKCg== --===============7333293368642956537==--