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 1ujPRZ-007Gs4-V4 for pgsql-bugs@arkaria.postgresql.org; Tue, 05 Aug 2025 21:43:38 +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 1ujPRY-00CJmP-1Y for pgsql-bugs@arkaria.postgresql.org; Tue, 05 Aug 2025 21:43:36 +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 1ujPBb-00C0YZ-Cv for pgsql-bugs@lists.postgresql.org; Tue, 05 Aug 2025 21:27: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 1ujPBY-000vLr-2g for pgsql-bugs@lists.postgresql.org; Tue, 05 Aug 2025 21:27: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=AwDG5iS0oHijnyEjQO50KShIaR5FPgmfEbLR+vE1iyQ=; b=Q16UGFOWal389uXr4S2J2MXJAx Ivy24cqQWJnTGpRo/P3w/XPyPEwZ5UpuXrCMF23dZnJuW/6A9LKZ8bhqWIklwt2fq58DhV1p6Nw+E PN7+hcXHEbCKlClLOib5pCRY/4cvyD8Tah4fiy22jk5nvVes0Qn+NT44lvZUfJsBxzbIAqcLUoIMq zmPkgVAL1mYQhDSwX9aK3Yng80bAb+69Y/VKI2NVIeGH4oxvxcXv2voRxEylXE79FdsC46IPzzu69 KfL7Dltek6NXZUPUQpuurS5tDrjp4BY76qPaDhlVNkNtBV/DFHMszjiKBEmAZQyTfmKvKNrVNl0RE NvK4Wlqw==; 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 1ujPBY-002WsQ-9F for pgsql-bugs@lists.postgresql.org; Tue, 05 Aug 2025 21:27:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1ujPBW-004t7B-2m for pgsql-bugs@lists.postgresql.org; Tue, 05 Aug 2025 21:27:03 +0000 Content-Type: multipart/mixed; boundary="===============7377970915899561960==" MIME-Version: 1.0 Subject: BUG #19013: When creating a table with the "...LIKE...INCLUDING ALL" construct, REPLICA IDENTITY output is wrong To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: dbman@sqlexec.com Reply-To: dbman@sqlexec.com, pgsql-bugs@lists.postgresql.org Date: Tue, 05 Aug 2025 21:26:56 +0000 Message-ID: <19013-04a5827d56b97202@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 --===============7377970915899561960== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxOTAxMwpMb2dnZWQgYnk6ICAgICAgICAgIE1pY2hhZWwgVml0YWxlCkVt YWlsIGFkZHJlc3M6ICAgICAgZGJtYW5Ac3FsZXhlYy5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiAx Ny41Ck9wZXJhdGluZyBzeXN0ZW06ICAgQ2VudE9TIDggU3RyZWFtcwpEZXNjcmlwdGlvbjogICAg ICAgIAoKSGVyZSBpcyBhIHNpbXBsZSBzY2hlbWEgdG8gdGVzdCB3aXRoOgpEUk9QIFNDSEVNQSBJ RiBFWElTVFMgdGVzdGluZyBDQVNDQURFOwpDUkVBVEUgU0NIRU1BIHRlc3Rpbmc7CkNSRUFURSBU QUJMRSB0ZXN0aW5nLm5vdGlmaWNhdGlvbnMKKAogICAgaWQgdXVpZCBOT1QgTlVMTCBERUZBVUxU IHV1aWRfZ2VuZXJhdGVfdjQoKSwKICAgIGVtcGxveWVlX2lkIHV1aWQgTk9UIE5VTEwsCiAgICBz ZWVuX2F0IHRpbWVzdGFtcCB3aXRoIHRpbWUgem9uZSwKICAgIGNyZWF0ZWRfYXQgdGltZXN0YW1w IHdpdGggdGltZSB6b25lIERFRkFVTFQgbm93KCksCiAgICBsYXN0X2NoYW5nZWQgdGltZXN0YW1w IHdpdGggdGltZSB6b25lIE5PVCBOVUxMIERFRkFVTFQgbm93KCksCiAgICBmaWxlX2lkIHV1aWQg Tk9UIE5VTEwsCiAgICBjb252ZXJzYXRpb25faWQgdXVpZCwKICAgIGRvY3VtZW50X2lkIHV1aWQs CiAgICBtZXNzYWdlX2lkIHV1aWQsCiAgICBDT05TVFJBSU5UIG5vdGlmaWNhdGlvbnNfcGtleSBQ UklNQVJZIEtFWSAoaWQpCikgVEFCTEVTUEFDRSBwZ19kZWZhdWx0OwpBTFRFUiBUQUJMRSBPTkxZ IHRlc3Rpbmcubm90aWZpY2F0aW9ucyBSRVBMSUNBIElERU5USVRZIEZVTEw7CkFMVEVSIFRBQkxF IElGIEVYSVNUUyB0ZXN0aW5nLm5vdGlmaWNhdGlvbnMgT1dORVIgdG8gcG9zdGdyZXM7CgotLSBW YWxpZGF0ZSB0YWJsZSBpcyBkZWZpbmVkIHdpdGggUkVQTElDQSBJREVOVElUWSBGVUxMClNFTEVD VCBuLm5zcG5hbWUgQVMgc2NoZW1hX25hbWUsIGMub2lkLCBjLnJlbG5hbWUgQVMgdGFibGVfbmFt ZSwKYy5yZWxyZXBsaWRlbnQsIGkuaW5kaXNyZXBsaWRlbnQsICBpZHhfYy5yZWxuYW1lIEFTCnJl cGxpY2FfaWRlbnRpdHlfaW5kZXhfbmFtZSwKQ0FTRSBjLnJlbHJlcGxpZGVudCBXSEVOICdkJyBU SEVOICdERUZBVUxUJyBXSEVOICduJyBUSEVOICdOT1RISU5HJyBXSEVOICdmJwpUSEVOICdGVUxM JyBXSEVOICdpJyBUSEVOICdJTkRFWCcgRU5EIEFTIHJlcGxpY2FfaWRlbnRpdHlfc2V0dGluZwpG Uk9NIHBnX2NsYXNzIGMgSk9JTiBwZ19uYW1lc3BhY2UgbiBPTiBuLm9pZCA9IGMucmVsbmFtZXNw YWNlIExFRlQgSk9JTgpwZ19pbmRleCBpIE9OIGkuaW5kcmVsaWQgPSBjLm9pZCBBTkQgaS5pbmRp c3JlcGxpZGVudCA9IFRSVUUgTEVGVCBKT0lOCnBnX2NsYXNzIGlkeF9jIE9OIGlkeF9jLm9pZCA9 IGkuaW5kZXhyZWxpZApXSEVSRSBuLm5zcG5hbWUgPSAndGVzdGluZycgQU5EIGMucmVsa2luZCA9 ICdyJzsKIHNjaGVtYV9uYW1lIHwgIG9pZCAgfCAgdGFibGVfbmFtZSAgIHwgcmVscmVwbGlkZW50 IHwgaW5kaXNyZXBsaWRlbnQgfApyZXBsaWNhX2lkZW50aXR5X2luZGV4X25hbWUgfCByZXBsaWNh X2lkZW50aXR5X3NldHRpbmcKLS0tLS0tLS0tLS0tLSstLS0tLS0tKy0tLS0tLS0tLS0tLS0tLSst LS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tCiB0ZXN0aW5nICAgICB8IDU4NDMxIHwgbm90 aWZpY2F0aW9ucyB8IGYgICAgICAgICAgICB8ICAgICAgICAgICAgICAgIHwKfCBGVUxMCgotLSBD cmVhdGUgYW5vdGhlciB0YWJsZSB1c2luZyB0aGUgTElLRSBjb25zdHJ1Y3QKQ1JFQVRFIFRBQkxF IHRlc3Rpbmcubm90aWZpY2F0aW9uczIgKExJS0UgdGVzdGluZy5ub3RpZmljYXRpb25zIElOQ0xV RElORwpBTEwpOwoKLS0gUnVuIHRoZSBxdWVyeSBhZ2FpbjoKU0VMRUNUIG4ubnNwbmFtZSBBUyBz Y2hlbWFfbmFtZSwgYy5vaWQsIGMucmVsbmFtZSBBUyB0YWJsZV9uYW1lLApjLnJlbHJlcGxpZGVu dCwgaS5pbmRpc3JlcGxpZGVudCwgIGlkeF9jLnJlbG5hbWUgQVMKcmVwbGljYV9pZGVudGl0eV9p bmRleF9uYW1lLApDQVNFIGMucmVscmVwbGlkZW50IFdIRU4gJ2QnIFRIRU4gJ0RFRkFVTFQnIFdI RU4gJ24nIFRIRU4gJ05PVEhJTkcnIFdIRU4gJ2YnClRIRU4gJ0ZVTEwnIFdIRU4gJ2knIFRIRU4g J0lOREVYJyBFTkQgQVMgcmVwbGljYV9pZGVudGl0eV9zZXR0aW5nCkZST00gcGdfY2xhc3MgYyBK T0lOIHBnX25hbWVzcGFjZSBuIE9OIG4ub2lkID0gYy5yZWxuYW1lc3BhY2UgTEVGVCBKT0lOCnBn X2luZGV4IGkgT04gaS5pbmRyZWxpZCA9IGMub2lkIEFORCBpLmluZGlzcmVwbGlkZW50ID0gVFJV RSBMRUZUIEpPSU4KcGdfY2xhc3MgaWR4X2MgT04gaWR4X2Mub2lkID0gaS5pbmRleHJlbGlkCldI RVJFIG4ubnNwbmFtZSA9ICd0ZXN0aW5nJyBBTkQgYy5yZWxraW5kID0gJ3InOwogc2NoZW1hX25h bWUgfCAgb2lkICB8ICAgdGFibGVfbmFtZSAgIHwgcmVscmVwbGlkZW50IHwgaW5kaXNyZXBsaWRl bnQgfApyZXBsaWNhX2lkZW50aXR5X2luZGV4X25hbWUgfCByZXBsaWNhX2lkZW50aXR5X3NldHRp bmcKLS0tLS0tLS0tLS0tLSstLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0r LS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLQogdGVzdGluZyAgICAgfCA1ODQzMSB8IG5vdGlmaWNhdGlvbnMgIHwg ZiAgICAgICAgICAgIHwgICAgICAgICAgICAgICAgfAp8IEZVTEwKIHRlc3RpbmcgICAgIHwgNTg0 MzkgfCBub3RpZmljYXRpb25zMiB8IGQgICAgICAgICAgICB8ICAgICAgICAgICAgICAgIHwKfCBE RUZBVUxUCigyIHJvd3MpCgo= --===============7377970915899561960==--