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 1ujhNX-00AuwU-0b for pgsql-bugs@arkaria.postgresql.org; Wed, 06 Aug 2025 16:52:39 +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 1ujhNT-00GvKG-P4 for pgsql-bugs@arkaria.postgresql.org; Wed, 06 Aug 2025 16:52: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 1ujhNT-00GvK8-EZ for pgsql-bugs@lists.postgresql.org; Wed, 06 Aug 2025 16:52:35 +0000 Received: from mout.perfora.net ([74.208.4.194]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1ujhNQ-0016DQ-2f for pgsql-bugs@lists.postgresql.org; Wed, 06 Aug 2025 16:52:34 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=sqlexec.com; s=s1-ionos; t=1754499150; x=1755103950; i=dbman@sqlexec.com; bh=2KMdJ/ebWrd6wbL3eJXVA9JWgOSMz46Hb/1lhMTVhb4=; h=X-UI-Sender-Class:Message-ID:Date:MIME-Version:Subject:To:Cc: References:From:In-Reply-To:Content-Type: Content-Transfer-Encoding:cc:content-transfer-encoding: content-type:date:from:message-id:mime-version:reply-to:subject: to; b=Y2qZU+PSxuIWafdsixN6oj2aLfMOaaD6SjfndHBaGJ+uG4GD0Zp10e0TYfa4eDz9 eaRRKZBNlzTEJJTUOdLEI3b6+ifCI5+G9y8pnkfvvkLSmXhxjYPnnCauBWF/RXfy9 7/PKacAPUesHGcMsWaqms62vwHyeNA8sCSo+oAwqNTZkjqXZMA/80mtK2uxczGAXc yQutRVKQ/FdXN0xQSJPJvJyyKlHlboYEclvFHKjFU2iNBfvrzp31fTqQmlc4A6Ub9 YwpgU0rF77l+peZLhA59BRJmD/n34n/dKSfyXvZiYeJMKhqa8uqr7LLVGuDng534S rnkd8HBRyBBF7h4C8Q== X-UI-Sender-Class: 55c96926-9e95-11ee-ae09-1f7a4046a0f6 Received: from [192.168.0.143] ([73.171.48.12]) by mrelay.perfora.net (mreueus003 [74.208.5.2]) with ESMTPSA (Nemesis) id 0MKpCY-1ujhNO2b20-008fvJ; Wed, 06 Aug 2025 18:52:30 +0200 Message-ID: Date: Wed, 6 Aug 2025 12:52:28 -0400 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: BUG #19013: When creating a table with the "...LIKE...INCLUDING ALL" construct, REPLICA IDENTITY output is wrong Content-Language: en-US To: Kirill Reshke Cc: "David G. Johnston" , "pgsql-bugs@lists.postgresql.org" References: <19013-04a5827d56b97202@postgresql.org> From: "dbman@sqlexec.com" In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: quoted-printable X-Provags-ID: V03:K1:8LLYW2We9TyGvI+2z94YcjQ1DbQHAm2OXhym+9vw4sz89zt3psi JFb4sgsaT/09++/P9Ud6Yet4V3JNlsGwEdbRwp2wfs27ujLxb/mSm1rPqPJkv2e6ewT22Bd pmbI//oOx5oIoPZ5G85skLv7aopfn1X1ysXhhJK0KaeYTFqkQjz6iL+PNieR+C88PgUEtWq aGm1YUZOy47jB/vr33ZjQ== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:TNYHYYVCJ+s=;VxBr4086SzcBRLZt85UPljnDR7U zr5tnPFv1wu/0xQENTxLO0CsKVt92a/bZKnOKuEVMEk9JToCCbsuyvEhZTxMqYcyGiV03pKVg kG9HFvvNhKIDYW0f1Cbc5N2eQl2tbEFM2CGCOl4kmKGC2r6ciDzqksIBMhFkobU54F3chm3LA 1wrWV4dKAJkDiw4kfhA/Vl39EbLFiG5WBpajmdCIMXl6uvNsQcRdba6IODU9g46a/YLfuMqFU MgrYH8AjggZisK0+Jh6hK0FYd6E9nuINmIGRCb4dJ0QLji9P9RgKBiYgvcEAKwWB4RrWCchhE LdH828SBOVi2g+wWDD9uNpVCEbyF3VWdsaK1Elh5lD5HxeZEccvwXji7p45EbbAW6TTUqWcaF 1AAhsFIFgDdnkEqRKgWW7PfJipyaEi+HclC1t1+vD4oNzfgSafukFrw/HmXNEDaTco3wZi2ie TvDz+l+ogFjRojPYFmuynKvm7/4Ux/yE05zFa1L3YOioe9/A7Zx/VRun3M9r4YL6h2QpJ0lIi SrO1W7EAd4Qub9xgkPSXkp+WQTqMEXbtOL46t2PKy7GJfucuC5tFRSo3N5wrpFHlksrHUC81k BiOhWJVF+dWblXy+r78/MoIRLMIjiaYUsWbF5HMkpX3cGaGlWiHsmYu/O3poyoM4krGn2gJ/G jVrF6tC6eQpr0gkUgeKO4THa6Drir5sRY6SvjvaqkWE9o2Xz0RSJRVvL8c1sDgut3Jroil2RS +knyNRS5lNBkUT4PQ1O0ue5smf2ZZxuotsbAv8kTbHrWmyID6cKDZOwm+yfXYPIe/kHZaXF+W dL9UJPzdNnGSTSh98c6oKEyZdt44E6qLARFwxFA0gR5aYTKlkTozE0862WHYtA2CBbkx/fATB CePDIUoyGfq9oeRZ0f6yureXnXMM5rjOQw/nR2w32ngWBiw/5U8Wn5VeVrfJ4nK2ckH9/3E1P jJVIe0J3gg1Lt5sXDiAxH2j0zZpK8B0WY0jEGmLvNAOOBNl1Jl5Sn+N9v/RG1L4nvrnXDbKBX K4h3E+2lr6lU0NSCsAREYzYak1oAiZtjqQ1jP2Ot1AkuWIFFWYjENAn5tpubx6i4/IuLtAYwd qzK1eOeSP7UgzbEXjzuuxoNtZsvEuhXbYqMzo4IFs1n+W7hoxSfmLCbfbbKufe7TZ6p6MLxq+ D7/fDVL8H4psrVyAZyZoWG09frKTc9fnayq+j9DWFt4rjjsVQrrmPlJMlsYzfVih/vb3KKXMy KuluB77xL7/taqQMiAG1la++fok7gQQREEYH7pzjRbMeYfjKt+TVQq0P1MS1LC9YuRg8vxV2L 4BFYbAMZPblwhvG/L3Ukqsp0JQEsiPALp/YcvjBWS9P7c5SG432zIJmbHGEPRmXk1opoDaIpO MpIsqCkecFNCsGuKlMPK+vRA+N3o54sz5+RSwWwFCXh8COMLjeQ6xRUVy8GvR9njjxpzuievM VGmy1sCyWJvlB6SkgUo/eNDiT0a78cylHddfw4kClGuOm1MbIs3IpL3o/Bq1ygJHrpS6UGzUO xSVJV4uZQ/rM4qUstJUkiiGedtgXhqCsXmOSKPDY+tYPrayDsDHJ5kSQD0Rmm0qPjeDB65uIr SZ6t/Vart1f5itOhyJtfq9j3kxRwLpc List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 8/6/2025 12:32 PM, Kirill Reshke wrote: > It's hard (to me, at least) to say what is `intended` DDL here. Why is it hard?=C2=A0 If the pg_dump output or /d schema.tablename output= =20 indicates a REPLICA IDENTITY of either FULL or INDEX, then it seems it=20 should be obvious that the CREATE TABLE ... LIKE output should be=20 similar, but instead it will show REPLICA IDENTITY DEFAULT. Regards, Michael V