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-000IT6-1Q 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-004k1P-2p for pgsql-hackers@arkaria.postgresql.org; Thu, 09 Apr 2026 08:51:30 +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.96) (envelope-from ) id 1wAkJ0-004JI7-1I for pgsql-hackers@lists.postgresql.org; Thu, 09 Apr 2026 08:00:03 +0000 Received: from mail-dy1-x1342.google.com ([2607:f8b0:4864:20::1342]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wAkIz-0000000088K-1LpO for pgsql-hackers@lists.postgresql.org; Thu, 09 Apr 2026 08:00:02 +0000 Received: by mail-dy1-x1342.google.com with SMTP id 5a478bee46e88-2cf1646bd11so802720eec.1 for ; Thu, 09 Apr 2026 01:00:01 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1775721600; cv=none; d=google.com; s=arc-20240605; b=Lp0yCZ6pN50H/6vvuwM7DplPSeyNZ5xltgHSUBwX3kkQSE33hH8oZx7fntDu62Q6M0 06SWfEhI/U7wpFeG9onGWgaP8QGbJblMpSIKU8koDPUBUkkjoY7VRssY5q71NL3nLQoC B95Icyda0YL7y8gJOdANOZ5rSaLpPR35xq6oJaoxa3+45PRvjWgNuBLMVmN2GXv1gQEE OvO52xrzcygBqKM2zM0EyZiYTnJFh92tl+WhYdiZBO9rbG8/aBovDn5nzglQpGRAeo6m 0aZCYjCMaS1YiUawlS9nqukWf3EyK0eR4g9IZh50zlcAvqmQtIqe/PN6jJoeUG3y65/+ +21Q== 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=rtVAdGj46QlVnbLozoPWaCj0/Ovokgo4F+9TFCGXGgo=; fh=nwNxTtLLPTU0ewfLM7SSbrjMajMl+wwnFkCY/fi90vE=; b=eRRFlWv+p+EZx2YQQlNXJXhDGLJQoyI5jYvgSNfcTUwNaLTc/mDEtwzBoYhgJYlyAg drOuhGUdYt9TYJSXRGyiaVtcjicbHSKe5iTEJEx14TMPMSRcG3ntfb93PhJhj7DYGK0W /H5WBsBDThLgag8BRrvm1kSWOwl7Y9dcUCuXIpWNV6n7uUoJ7vGMwHd/pmT3yDBwLMXY fP0TO3ORZ1FSRZvqZFOiLSxuzVykPBy6BUyOjieNTii8iyUPXslok4r7vCKXrvO0c8uL avV8bmnuQQ5/C1slVR98ah2c7REBzfgjim2ipxvQ4ZIycYtqI7ojPzLEl44PvMbVLtL4 2hqw==; 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=1775721600; x=1776326400; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=rtVAdGj46QlVnbLozoPWaCj0/Ovokgo4F+9TFCGXGgo=; b=NxHTmvt7IxaKKTMDMmUULWuGpV1nYKlOm7kJVWIAo1jfIV5DoEZx0DOvB/nCwHBzJF v+lez9xCYu1HW9JjiHcyGgIcBbQmFDGs2/W76VQvgl5oYcQUqjzfIRf0umBip+r+dFxI UrL7DXgxqEfwPOGGvVqNSwWNJqxNqcH9Nilgzxg5hAExU6O6DHSmZR96D2nxj6IGGV1l rKdjbAJCSpY83ks6iRv2LfvpdICu26fcERjG9rDQbwzZJENGDL1TueVZlWJfjiDR3u+u AwATkjaGu9fNDEzPjJKjETd88QYcKcuXle6CpbTNFvuCSf8H9W2o+uCx55svUK8SAa6O dZOw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1775721600; x=1776326400; 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=rtVAdGj46QlVnbLozoPWaCj0/Ovokgo4F+9TFCGXGgo=; b=jUIJDT0HAkahIOTiG/VygIHg+MhXzsVStyiNWTIRUeFLr2pj0hWo9+9CNNTh1+tB/N PZlXcE41B0G84e9XZ8+Hv/dCfClJiKy5kgxYfgLsVNZnu0qi6e8mtg2Wj0cgMmWVsbhQ ltScEkv+PAehfUlP+b8Fem8Fl8uuN3fkZXlNSGDTGjzcviAXydD1gVN1X4CNSEH8JCmH T9K8rtG2/uslEJ9z0DhC7SBHDeMdlM203UmpMnqzZekEP9KbdPzwOo33f38HLgtt0dSl F/iSmZfi0ju3TesHJHq0j2yv1uB4phCuVgJU2nly8PgQjJjIr7IvoqJfasCvjPpZ6mEh MVkA== X-Gm-Message-State: AOJu0YzF62CyqVHBRWjkzVWUS8TPEh21IRBNrS6MVauuX6SaInsNxS05 O3/IMtpeYe+egvOw4FZO8jxaK6grGG4IKHHft9ARTQjsq41nrOd6o+4njtEwWuMHR3hNsKEsmLQ aPrQy5l/WXdprYCrvE+qvcIwxQGPAMs9U9yv7SPkt5zwQwIM= X-Gm-Gg: AeBDietBkhlTlh4EK6XNnieUVc8uDYmgMSvGXuaEqI01ZFCcVpMF89pfwXf5PnuCtdD iU+reZ7OSl/rEAiQhEB0G5oyvVokWnYM6xrrYSG6o33QWXOWeO/Nih7Oj2n6u120x6KHDjSGCee 7U0mKEoKmfyEHpv8SbC2xag2trdmJ1/pBZARLcZZfUKYyDgkTM71DZykqCRS86E/HxrqJUOfpra YPP2yLoW09cFIcDzRqVpXni49oCNPJMfApSbj0ufDijzVaf3AG2IE6e2dlqSbcV/CXaSgZurUTR TiQNPg== X-Received: by 2002:a05:7300:2153:b0:2c7:287:6740 with SMTP id 5a478bee46e88-2cbfc45b1cemr13205482eec.28.1775721600124; Thu, 09 Apr 2026 01:00:00 -0700 (PDT) MIME-Version: 1.0 From: Dapeng Wang Date: Thu, 9 Apr 2026 15:59:46 +0800 X-Gm-Features: AQROBzDG1D6C60ou0GXdaq7cmNGd16rpXjl6GMQj0zEIP5ooh7dve7exTLy9aeY Message-ID: Subject: Re: create table like including storage parameter To: pgsql-hackers@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000320cc8064f02677a" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000320cc8064f02677a 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 --000000000000320cc8064f02677a 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
--000000000000320cc8064f02677a--