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 1uCnQm-002OAB-8A for pgsql-bugs@arkaria.postgresql.org; Wed, 07 May 2025 22:40:00 +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 1uCnQl-00H2Id-6t for pgsql-bugs@arkaria.postgresql.org; Wed, 07 May 2025 22:39:59 +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.94.2) (envelope-from ) id 1uCm9X-00GP9a-LB for pgsql-bugs@lists.postgresql.org; Wed, 07 May 2025 21:18:07 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uCm9U-000eaG-2X for pgsql-bugs@lists.postgresql.org; Wed, 07 May 2025 21:18:06 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=0TKYaYwFiJOholb2N+egACxCY26lZvdZ1EnJ9AYorPU=; b=cf5nUVk3xZlr+ztIYzH3KGFhG9 EvO7kQMLklYkagHWrg4B2xFCl9XnKiS+yqvNkK0oSxtlo5xwXUYdBVCFtCzEeZScU7L+jGFz/NKrs /0cEoZYgDAzW89mqkl09JDpqiNYKfPenKxhCdD2aqHt6A1nu0fQXhWPVE1uuKyVvTdEmZYzSTt9ly rUBe2KLLfwM2+gQC8EZP2/Hucwv3IMoGSPMiDzsApnnr64H16SHzVmY2YC1VGGtI866pOoMyD7q4u LsqMiqQoKUrtgHmAyp9t1eAdiR1Qew+Eaq9/ItF2/v/Z7Otr8OdeciiK7TZgMjdBLUzMEHwrpnYh8 6w53yVww==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uCm9U-001tW5-Ha for pgsql-bugs@lists.postgresql.org; Wed, 07 May 2025 21:18:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uCm9T-00AEKF-2G for pgsql-bugs@lists.postgresql.org; Wed, 07 May 2025 21:18:03 +0000 Content-Type: multipart/mixed; boundary="===============1285981008679839391==" MIME-Version: 1.0 Subject: BUG #18916: alter table ... set (n_distinct=) completely ignored on partition head and/or individual partitions To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: maxim.boguk@gmail.com Reply-To: maxim.boguk@gmail.com, pgsql-bugs@lists.postgresql.org Date: Wed, 07 May 2025 21:18:00 +0000 Message-ID: <18916-985c04e9b5bed12b@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1285981008679839391== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODkxNgpMb2dnZWQgYnk6ICAgICAgICAgIE1heGltIEJvZ3VrCkVtYWls IGFkZHJlc3M6ICAgICAgbWF4aW0uYm9ndWtAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjog MTcuNApPcGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dQpEZXNjcmlwdGlvbjogICAgICAgIAoKSGks CkkgZG9uJ3Qga25vdyBpdCdzIG1pc3NpbmcgZmVhdHVyZSBvciBhY3R1YWwgYnVnIGluIGNhc2Ug b2YgbmF0aXZlCnBhcnRpdGlvbmluZwphbHRlciB0YWJsZSBwYXJ0aXRpb25faGVhZCBhbHRlciBz b21lZmllbGQgc2V0IChuX2Rpc3RpbmN0PS4uLikKYW5kL29yIGFsdGVyIHRhYmxlIGluZGl2aWR1 YWxfcGFyaXRpdGlvbiBhbHRlciBzb21lZmllbGQgc2V0CihuX2Rpc3RpbmN0PS4uLikKc2ltcGxl IGhhdmUgbm8gZWZmZWN0IGluIGRpc3RpbmN0IHNvbWVmaWVsZCBlc3RpbWF0aW9ucywgdGh1cyBs ZWFkaW5nIHRvCnZlcnkgYmFkIHBsYW5zLgpJbiBteSBwYXJ0aWN1bGFyIGNhc2UgKGpvYl9zdGF0 c19tYXN0ZXIgcGFydGl0aW9uZWQgYnkgdGltZXN0YW1wIHRvIDI0Cm1vbnRobHkgcGFydGl0aW9u cyk6CnNvbWVkYj0jIGV4cGxhaW4gYW5hbHl6ZSAgc2VsZWN0IGRpc3RpbmN0IGlwX21hdGNoaW5n X2lkIGZyb20Kam9iX3N0YXRzX21hc3RlciB3aGVyZSAgKChjcmVhdGVkX2F0ID49ICcyMDI1LTA0 LTAxJzo6ZGF0ZSkgQU5EIChjcmVhdGVkX2F0CjwgJzIwMjUtMDUtMDEnOjpkYXRlKSk7ClFVRVJZ IFBMQU4KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLQogVW5pcXVlICAoY29zdD03NjQ1NTgwLjUzLi44MDI0NDMy LjUxIHJvd3M9NjM4MjM1IHdpZHRoPTgpIChhY3R1YWwKdGltZT0yMzQ1My4zMTguLjQ5NzgyLjY4 MiByb3dzPTMyMjQ4OTA4IGxvb3BzPTEpCi4uLgogICAgICAgICAgICAgICAgICAgICAtPiAgUGFy YWxsZWwgU2VxIFNjYW4gb24gam9iX3N0YXRzX25ld18yMDI1XzA0CmpvYl9zdGF0c19tYXN0ZXIg IChjb3N0PTAuMDAuLjIwNTYxMzAuNDEgcm93cz00Mzc1NjkxMiB3aWR0aD04KSAoYWN0dWFsCnRp bWU9MTYyLjcyMS4uMTQzODQuMzI0IHJvd3M9Mzg4OTM0NzAgbG9vcHM9OSkKICAgICAgICAgICAg ICAgICAgICAgICAgICAgRmlsdGVyOiAoKGNyZWF0ZWRfYXQgPj0gJzIwMjUtMDQtMDEnOjpkYXRl KSBBTkQKKGNyZWF0ZWRfYXQgPCAnMjAyNS0wNS0wMSc6OmRhdGUpKQphbG1vc3QgMiBvcmRlciBv ZiBtYWduaXR1ZGUgZXJyb3IKTm93IHRyeSBzZXQgbl9kaXN0aW5jdCB0byBmaXggZXN0aW1hdGVz OgotLXRyeWluZyBuX2Rpc3RpbmN0IG9uIGhlYWQgKC0xIHRvIHNpbXBsaWZ5IGNoZWNrcykKYWx0 ZXIgdGFibGUgIGpvYl9zdGF0c19tYXN0ZXIgYWx0ZXIgaXBfbWF0Y2hpbmdfaWQgc2V0IChuX2Rp c3RpbmN0PS0xKTsKYW5hbHl6ZSBqb2Jfc3RhdHNfbWFzdGVyOwphbmFseXplIGpvYl9zdGF0c19u ZXdfMjAyNV8wNDsKZXhwbGFpbiBzZWxlY3QgZGlzdGluY3QgaXBfbWF0Y2hpbmdfaWQgZnJvbSBq b2Jfc3RhdHNfbWFzdGVyIHdoZXJlCigoY3JlYXRlZF9hdCA+PSAnMjAyNS0wNC0wMSc6OmRhdGUp IEFORCAoY3JlYXRlZF9hdCA8ICcyMDI1LTA1LTAxJzo6ZGF0ZSkpOwogVW5pcXVlICAoY29zdD00 MDU4NTY2LjA0Li40MjEwMzcwLjczIHJvd3M9NTk5MzE1IHdpZHRoPTgpCi0tbm8gZWZmZWN0IG9u IGVzdGltYXRlcwotLXRyeWluZyBuX2Rpc3RpbmN0IG9uIGluZGl2aWR1YWwgcGFydGl0aW9uCmFs dGVyIHRhYmxlICBqb2Jfc3RhdHNfbWFzdGVyIGFsdGVyIGlwX21hdGNoaW5nX2lkIHJlc2V0IChu X2Rpc3RpbmN0KTsKYWx0ZXIgdGFibGUgam9iX3N0YXRzX25ld18yMDI1XzA0ICBhbHRlciBpcF9t YXRjaGluZ19pZCBzZXQgKG5fZGlzdGluY3Q9LTEpOwphbmFseXplIGpvYl9zdGF0c19tYXN0ZXI7 CmFuYWx5emUgam9iX3N0YXRzX25ld18yMDI1XzA0OwpleHBsYWluIHNlbGVjdCBkaXN0aW5jdCBp cF9tYXRjaGluZ19pZCBmcm9tIGpvYl9zdGF0c19tYXN0ZXIgd2hlcmUKKChjcmVhdGVkX2F0ID49 ICcyMDI1LTA0LTAxJzo6ZGF0ZSkgQU5EIChjcmVhdGVkX2F0IDwgJzIwMjUtMDUtMDEnOjpkYXRl KSk7CiBVbmlxdWUgIChjb3N0PTQwNjE1ODAuMDQuLjQyMjY3MTguNTQgcm93cz02NTE5NTYgd2lk dGg9OCkKLS1hZ2FpbiBubyBlZmZlY3Qgb24gZXN0aW1hdGVzCi0tdHJ5aW5nIGJvdGgKYWx0ZXIg dGFibGUgIGpvYl9zdGF0c19tYXN0ZXIgYWx0ZXIgaXBfbWF0Y2hpbmdfaWQgc2V0IChuX2Rpc3Rp bmN0PS0xKTsKYWx0ZXIgdGFibGUgam9iX3N0YXRzX25ld18yMDI1XzA0ICBhbHRlciBpcF9tYXRj aGluZ19pZCBzZXQgKG5fZGlzdGluY3Q9LTEpOwphbmFseXplIGpvYl9zdGF0c19tYXN0ZXI7CmFu YWx5emUgam9iX3N0YXRzX25ld18yMDI1XzA0OwpleHBsYWluIHNlbGVjdCBkaXN0aW5jdCBpcF9t YXRjaGluZ19pZCBmcm9tIGpvYl9zdGF0c19tYXN0ZXIgd2hlcmUKKChjcmVhdGVkX2F0ID49ICcy MDI1LTA0LTAxJzo6ZGF0ZSkgQU5EIChjcmVhdGVkX2F0IDwgJzIwMjUtMDUtMDEnOjpkYXRlKSk7 CiBVbmlxdWUgIChjb3N0PTQwNTg1MzcuMTIuLjQyMTM1NDIuNDcgcm93cz02MTE5NTEgd2lkdGg9 OCkKLS11bmZvcnR1bmF0ZWx5IG5vIGVmZmVjdCBhcyB3ZWxsCktpbmQgUmVnYXJkcywKTWF4aW0K Cg== --===============1285981008679839391==--