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.96) (envelope-from ) id 1wAl6p-000IT5-1M for pgsql-hackers@arkaria.postgresql.org; Thu, 09 Apr 2026 08:51:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wAl6n-004k1N-2p for pgsql-hackers@arkaria.postgresql.org; Thu, 09 Apr 2026 08:51:30 +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.96) (envelope-from ) id 1wAPAi-006NOb-07 for pgsql-hackers@lists.postgresql.org; Wed, 08 Apr 2026 09:26:04 +0000 Received: from mail-dy1-x1343.google.com ([2607:f8b0:4864:20::1343]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wAPAg-00000001GzX-2Auv for pgsql-hackers@lists.postgresql.org; Wed, 08 Apr 2026 09:26:04 +0000 Received: by mail-dy1-x1343.google.com with SMTP id 5a478bee46e88-2bdd40d3c61so5387520eec.1 for ; Wed, 08 Apr 2026 02:26:02 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1775640360; cv=none; d=google.com; s=arc-20240605; b=A0uwac3L7EQ1gMzrLym98sIkyJlaWwINp/WebkpT9PW31qCkoODQ+X1cZVzusg4nBz tyiKYgRDVjoTfYbxSoFi70yPVO/uecN7XlmD01oCX4bjtIYkjQXzdb5bZi3FOCtqJI40 OvsVlTmkPp+Uw5Au7ZX1wJLOUocF8UWrsvW4cajeIrYWeR3Dn3ZAS1HdU4uh4JNUns6a GC//Yl4rIXBJN2ufVf/P83KYuEwoaq/7GWX0PRovou4hMXTHLhXyUccJ/0P3wqeHw74t k5RE1iKs/OGuRhmhRwuPoHanbgw3ogxDktPjjeVzFAezbPIgE2vc1Ppka3iOqdBMVxvp y5Vg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=to:subject:message-id:date:from:mime-version:dkim-signature; bh=6glbLa3Et0hFLNozt2WNojoJE8fjy1sxPSI8jTFYbF0=; fh=nwNxTtLLPTU0ewfLM7SSbrjMajMl+wwnFkCY/fi90vE=; b=WPlVx57aysMlF2dXDwXwTx5IpD+t4+doOGG43Ux/DoMH1QqmDYUUdHcL7dNyIgMNY7 zNXsKKmVmZIfr6QR8t+XPThZNgxyuNaHbM9DpEM/iuNILRspS/gTnnvJdahORC2YrBMC dpAM7YO2Zbr/lQNIchcG2roH0qeZfd8ALxvNXWZy/mIDEOiaZOZPVHkBMLsj0stT0sAN vGCL+R7GiOygHvSnRSkgKaVC99FOKEhMQF1hK6JW2dTDABScvQWx4XIWfDG2adDldwI0 rlu0F2Bjz+XMxte9IVZZJTwgAgVSUdL7jc5ygizIqtq3Ls0ZpvwdlegNpwd0gThgGyHi R6hQ==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1775640360; x=1776245160; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=6glbLa3Et0hFLNozt2WNojoJE8fjy1sxPSI8jTFYbF0=; b=PexgWc+IliwkbOdxNXZmpWzDS4Orgcvol5oEaYrofBtrVAvkT4quchGq2GpblCPprp 1EqXb0HsQyI8wqMQEXP+RjIEjumvPScgw1z8izgDFqnX3AjnVEGQg4WM0iInfDDfaPmv Omq+7GHb13n0gT9xPFf+4ex0oWpkAyOBnGEaqcAy3vV2WfLIzZWgEPj9Ez58FifL9zTQ yvhBQSwSGPYsiFKIa3NecYeXXlooFy0Vwy8ZlNhwgVuSdmVho/+RBu3NEdTI9ph4GPom Nggod3yThMajWS0qI2G67HsUUuCbLRHiT8xQv2cg9JrG5KPH/7fs3mpxrrSWSg41D2Hk jpMg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1775640360; x=1776245160; h=to:subject:message-id:date:from:mime-version:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=6glbLa3Et0hFLNozt2WNojoJE8fjy1sxPSI8jTFYbF0=; b=bCBcFM9/QIb4KY/3VUjlw9CQuV9wVl1iDFP11VEF6mVh7H/LY7MXHeDYfr9vqo90uO R6bOQeE9zbGeiLos5saqn4jFpBH/4WjUTqkTz/jY/KrHM59U69FkP/Ub/jOdhmYmm9PW pcFnIc7NVucddKAE44TRQ1Pm3TqrCFVm/vM6i7H27W/sIlLcTVilB5FIIAQpj/s5iYex TBMJdoB+gMI1eT/xWnFkA9m4VmL8+xIAmy9Vt7KjmM0X3aeRSjW/xd/XC3HdbfAo0oW7 zQWLkdCdNNjU5fbDUuAVUDsYlZb84MgYgKTc/9zJOUCHSMN9a9q2PTxHuATDxkbiNAGa dXsQ== X-Gm-Message-State: AOJu0YwDNdM9AS3GmDvD9OmA+QsIN44fycC7yUZhfXlV3Dxijie9xuHL pgxCXa/Mndtw1RKKsJj6wQ8JembjqQFfyNNI8sepBbfdZ45efEoZls9qzFhMjxXK2PD+hHf9lrn Fq4S/tCr87icGtclAIIFLNuvoC91SKwGw/KVGE60KznApLk8= X-Gm-Gg: AeBDieuH++T5FhdbVu2PQR6Ayn2qEc8p0Poi8z5YSa4ZQDd1nOywsSEhVgtGpOuutJz Ror9cOP+AC95BHbS2qDAA0vDNjRz3bTwSZH3GQ3XjbjqYVhQfahiFnkAfyueV/1InLVlbs5+5x3 sfOOnjXkPFnbC9Nr7y3lzAUf9e54BNH+lRKToMUqx7pJnpCwV93XAmTo9kQDnIyIvJokjn3ZU26 44vBaO8VVGiCoTZCTYY6Ru8RgZR8tOu6J1uns4LfCSvRQ5bfuaOLnxxPpMBQMUnq3n1aUgXfsus TDfUnypV X-Received: by 2002:a05:693c:2c93:b0:2be:1f58:32a3 with SMTP id 5a478bee46e88-2cbfcb5a35emr10054629eec.29.1775640359917; Wed, 08 Apr 2026 02:25:59 -0700 (PDT) MIME-Version: 1.0 From: Dapeng Wang Date: Wed, 8 Apr 2026 17:25:45 +0800 X-Gm-Features: AQROBzDFQ8KX3cd3qexKqE_6EY2B0SWxr0PnlQa2TmYJ9FvG9ugPCJRoX2OY9xk Message-ID: Subject: Re: create table like including storage parameter To: pgsql-hackers@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000e6dbdd064eef7c07" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000e6dbdd064eef7c07 Content-Type: text/plain; charset="UTF-8" Hi, I pulled the v9 patch and gave it a spin on 19devel. Everything I tried worked fine - basic parameter copying, merging with WITH clause, duplicate detection, EXCLUDING, and the VIEW/materialized view cases all behaved correctly. make check passed too (one unrelated ICU collation diff in collate.icu.utf8). Looks good to me. Regards, Dapeng Wang --000000000000e6dbdd064eef7c07 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi,

I pulled the v9 patch and gave it a spin on 19d= evel.

Everything I tried worked fine - basic parameter copying,
m= erging with WITH clause, duplicate detection, EXCLUDING,
and the VIEW/ma= terialized view cases all behaved correctly.

make check passed too (= one unrelated ICU collation diff
in collate.icu.utf8).

Looks good= to me.

Regards,
Dapeng Wang
--000000000000e6dbdd064eef7c07--