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 1vFVCP-00CWn6-9x for pgsql-bugs@arkaria.postgresql.org; Sun, 02 Nov 2025 10:20: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 1vFVCO-00AVkz-0Q for pgsql-bugs@arkaria.postgresql.org; Sun, 02 Nov 2025 10:20:35 +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 1vFGTT-006hzN-Dj for pgsql-bugs@lists.postgresql.org; Sat, 01 Nov 2025 18:37:14 +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.96) (envelope-from ) id 1vFGTN-005SK4-1c for pgsql-bugs@lists.postgresql.org; Sat, 01 Nov 2025 18:37:14 +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=N1j/cxQXgjetjE0CVfynqc7GaH08qN0Saq8vSu+9GYs=; b=rBpLu28su8CDkdH+0KHgRWf/it lsHFmF3ErA2LCmTw6ZUBclH8OUrOd1th2ikV16lS86wiVgClC972q/WRXZSav8dcXxyDSFReJGRi+ wCZevFNmpH5kLhYzqcSzoPlZSIdUazcIf4H6qAQd8Pw4RMc5dIVSysgvBHheZehl8OE7bOILyvvT4 aSJKJUOpFeldx2jkoCfvQmzCjcmPvjYbZ27gecxbpd6qNcVKAsd3sYDjtIukJv53bqb6CfvBb92o3 SWK2Np+ICaCEroxAyA4e3upaP8vItG+UeZPr7MLonYHDGTZdNda4CFvLz6Rd2HcEdeOtIFNcvgCy1 JPLlRQsA==; 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 1vFGTL-008V5B-I2 for pgsql-bugs@lists.postgresql.org; Sat, 01 Nov 2025 18:37:07 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vFGTG-005CzS-2f for pgsql-bugs@lists.postgresql.org; Sat, 01 Nov 2025 18:37:03 +0000 Content-Type: multipart/mixed; boundary="===============6771862526040636862==" MIME-Version: 1.0 Subject: BUG #19100: Different column type between partitioned table and detached pending partition table make errors To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: mohen.lhy@alibaba-inc.com Reply-To: mohen.lhy@alibaba-inc.com, pgsql-bugs@lists.postgresql.org Date: Sat, 01 Nov 2025 18:36:26 +0000 Message-ID: <19100-f676a0f5c4723b2f@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 --===============6771862526040636862== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxOTEwMApMb2dnZWQgYnk6ICAgICAgICAgIGhhaXlhbmcgbGkKRW1haWwg YWRkcmVzczogICAgICBtb2hlbi5saHlAYWxpYmFiYS1pbmMuY29tClBvc3RncmVTUUwgdmVyc2lv bjogMTguMApPcGVyYXRpbmcgc3lzdGVtOiAgIGFueQpEZXNjcmlwdGlvbjogICAgICAgIAoKSGVs bG8gYWxsLApSZWNlbnRseSBJIHJhbiBpbnRvIGFuIGlzc3VlIHdpdGggcGFydGl0aW9uZWQgdGFi bGVzIHdoZXJlIGEgZGV0YWNoCnBlbmRpbmcgY2hpbGQgdGFibGUgaGF2aW5nIGEgZGlmZmVyZW50 IGNvbHVtbiB0eXBlIGZyb20gaXRzIHBhcmVudApsZWQgdG8gdW5leHBlY3RlZCBlcnJvcnMuIEhl cmUgaXMgaG93IHRvIHJlcHJvZHVjZToKYGBgCi0tIHMxCkNSRUFURSBUQUJMRSB1c2VycyAoaWQg ICBpbnQsIG5hbWUgdGV4dCkgUEFSVElUSU9OIEJZIEhBU0ggKGlkKTsKCkNSRUFURSBUQUJMRSB1 c2Vyc19wMCBQQVJUSVRJT04gT0YgdXNlcnMKICAgIEZPUiBWQUxVRVMgV0lUSCAoTU9EVUxVUyA0 LCBSRU1BSU5ERVIgMCk7CkNSRUFURSBUQUJMRSB1c2Vyc19wMSBQQVJUSVRJT04gT0YgdXNlcnMK ICAgIEZPUiBWQUxVRVMgV0lUSCAoTU9EVUxVUyA0LCBSRU1BSU5ERVIgMSk7CkNSRUFURSBUQUJM RSB1c2Vyc19wMiBQQVJUSVRJT04gT0YgdXNlcnMKICAgIEZPUiBWQUxVRVMgV0lUSCAoTU9EVUxV UyA0LCBSRU1BSU5ERVIgMik7CkNSRUFURSBUQUJMRSB1c2Vyc19wMyBQQVJUSVRJT04gT0YgdXNl cnMKICAgIEZPUiBWQUxVRVMgV0lUSCAoTU9EVUxVUyA0LCBSRU1BSU5ERVIgMyk7CgpDUkVBVEUg SU5ERVggT04gdXNlcnMgKGlkKTsKCi0tczIKYmVnaW47CgpzZWxlY3QgKiBmcm9tIHVzZXJzOwoK LS0gczEKQUxURVIgVEFCTEUgdXNlcnMgZGV0YWNoIHBhcnRpdGlvbiB1c2Vyc19wMCBjb25jdXJy ZW50bHkgOwotLSBjYW5jZWwgcmVxdWVzdCB0byBhcmNoaXZlIGRldGFjaCBwZW5kaW5nIHN0YXR1 cwoKLS0gczIKcm9sbGJhY2s7CgotLSBzMQpBTFRFUiBUQUJMRSB1c2VycyBBTFRFUiBDT0xVTU4g bmFtZSBUWVBFIGNoYXIoMTApOwoKXGQrIHVzZXJzCi0tIGVycm9yClxkKyB1c2Vyc19wMApFUlJP UjogIGNvdWxkIG5vdCBjb252ZXJ0IHJvdyB0eXBlCkRFVEFJTDogIEF0dHJpYnV0ZSAibmFtZSIg b2YgdHlwZSB1c2VycyBkb2VzIG5vdCBtYXRjaCBjb3JyZXNwb25kaW5nCmF0dHJpYnV0ZSBvZiB0 eXBlIHVzZXJzX3AwLgoKXHEKCnBnX2R1bXAgLVUgeHh4IC1kIHh4eCAtcyAtdCB1c2VycyogPiB1 c2Vycy5zcWwKCi0tIGVycm9yCmNyZWF0ZSBkYXRhYmFzZSB0ZXN0OwpcYyB0ZXN0Ci0tIGVycm9y ClxpIHVzZXJzLnNxbAouLi4KcHNxbDp1c2Vycy5zcWw6ODk6IEVSUk9SOiAgY2hpbGQgdGFibGUg InVzZXJzX3AwIiBoYXMgZGlmZmVyZW50IHR5cGUgZm9yCmNvbHVtbiAibmFtZSIKLi4uCnBzcWw6 dXNlcnMuc3FsOjE1MjogRVJST1I6ICBjYW5ub3QgYXR0YWNoIGluZGV4ICJ1c2Vyc19wMF9pZF9p ZHgiIGFzIGEKcGFydGl0aW9uIG9mIGluZGV4ICJ1c2Vyc19pZF9pZHgiCkRFVEFJTDogIEluZGV4 ICJ1c2Vyc19wMF9pZF9pZHgiIGlzIG5vdCBhbiBpbmRleCBvbiBhbnkgcGFydGl0aW9uIG9mIHRh YmxlCiJ1c2VycyIuCi4uLgpgYGAKCkl0J3MgZXZpZGVudCB0aGF0IGluIGJvdGggZXJyb3IgY2Fz ZXMsIHRoZSBmYWlsdXJlIG9jY3VycyBiZWNhdXNlCmNvbHVtbiBuYW1lIGhhcyBkaWZmZXJlbnQg ZGF0YSB0eXBlcyBiZXR3ZWVuIHRoZSBwYXJlbnQgYW5kIHRoZSBjaGlsZAp0YWJsZS4gQlRXLCAi XGQrIHVzZXJzX3AwIiBlcnJvciBoYXBwZW5zIHdoZW4KcGdfZ2V0X3BhcnRpdGlvbl9jb25zdHJh aW50ZGVmKCkgaXMgY2FsbGVkLiBUaGUgcm9vdCBjYXVzZSBzZWVtcyB0byBiZQp0aGF0IHdoZW4g cnVubmluZzoKYGBgCkFMVEVSIFRBQkxFIHVzZXJzIEFMVEVSIENPTFVNTiBuYW1lIFRZUEUgY2hh cigxMCk7CmBgYApvbiB0aGUgcGFyZW50IHRhYmxlLCB0aGUgc3RhdGVtZW50IGRvZXMgbm90IGFm ZmVjdCBhIGNoaWxkIHRhYmxlIHRoYXQgaXMgaW4KZGV0YWNoIHBlbmRpbmcgc3RhdGUuCgpJTU8s IGEgZGV0YWNoIHBlbmRpbmcgY2hpbGQgdGFibGUgaXMgbm90IGFmZmVjdGVkIGJ5IHBhcmVudCdz IERNTCBvciBEUUwsCmJ1dCBzaG91bGQgc3RpbGwgYmUgYWZmZWN0ZWQgYnkgcGFyZW50J3MgRERM LiBNeSByZWFzb25pbmcgaXM6CgoxLiBBIGRldGFjaCBwZW5kaW5nIGNoaWxkIHRhYmxlIGhhcyBu b3QgYWN0dWFsbHkgYmVlbiBkZXRhY2hlZCB5ZXQ7IG9ubHkKcGdfaW5oZXJpdHMuaW5oZGV0YWNo cGVuZGluZyBpcyBtYXJrZWQgYXMgdHJ1ZS4gSW4gb3RoZXIgcmVzcGVjdHMsIGl0IGlzCnN0aWxs IHRoZSBzYW1lIGFzIGFueSBvdGhlciBjaGlsZCBwYXJ0aXRpb24uIElmIERETCBjaGFuZ2VzIGFy ZSBub3QKcHJvcGFnYXRlZCwKcnVubmluZyB0aGUgc2FtZSBjb21tYW5kIGxhdGVyIG9uIHRoZSBk ZXRhY2ggcGVuZGluZyBjaGlsZCBtYXkgcHJvZHVjZQp1bmV4cGVjdGVkIGVycm9ycyAoZS5nLiB3 aGVuIGNhbGxpbmcgcGdfZ2V0X3BhcnRpdGlvbl9jb25zdHJhaW50ZGVmKCkpLgoKMi4gT3RoZXIg cGFydGl0aW9uIG9iamVjdHMgb24gYSBkZXRhY2ggcGVuZGluZyBjaGlsZCAoZS5nLiBpbmRleGVz KSBhcmUgbm90Cm1hcmtlZCBhcyAiZGV0YWNoIHBlbmRpbmciIHRoZW1zZWx2ZXMuIElmIHlvdSBE Uk9QIElOREVYIG9uIHRoZSBwYXJlbnQsIHRoZQpkcm9wCmlzIHN0aWxsIHByb3BhZ2F0ZWQgYW5k IHRoZSBpbmRleCBvbiB0aGUgY2hpbGQgaXMgcmVtb3ZlZC4gRHJvcHBpbmcgdGhlCnBhcmVudAp0 YWJsZSB3aWxsIGFsc28gZHJvcCBhIGRldGFjaCBwZW5kaW5nIGNoaWxkIHRhYmxlLiBUaHVzLCBz b21lIERETCBmcm9tIHRoZQpwYXJlbnQKaXMgc3RpbGwgYXBwbGllZCB0byBkZXRhY2ggcGVuZGlu ZyBjaGlsZHJlbiwgY3JlYXRpbmcgYSBjb25mdXNpbmcgcGFydGlhbApzdGF0ZS4KCkxvb2tpbmcg Rm9yd2FyZCB0byB5b3VyIGZlZWRiYWNrLgoKUmVnYXJkcywKSGFpeWFuZyBMaQoK --===============6771862526040636862==--