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 1voN94-002I2Z-39 for pgsql-hackers@arkaria.postgresql.org; Fri, 06 Feb 2026 14:49:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1voN94-004FLW-0E for pgsql-hackers@arkaria.postgresql.org; Fri, 06 Feb 2026 14:49:17 +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 1voN93-004FLN-2M for pgsql-hackers@lists.postgresql.org; Fri, 06 Feb 2026 14:49:17 +0000 Received: from mail-yw1-x1133.google.com ([2607:f8b0:4864:20::1133]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1voN90-00000001NS7-1I5U for pgsql-hackers@postgresql.org; Fri, 06 Feb 2026 14:49:16 +0000 Received: by mail-yw1-x1133.google.com with SMTP id 00721157ae682-790b7b3e594so24323127b3.3 for ; Fri, 06 Feb 2026 06:49:13 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1770389352; cv=none; d=google.com; s=arc-20240605; b=bEuwtSQqjQnHBXCFMOa4yJyvt55rMpjbyYfz+KFSFmwseryygpgbQDEacVOoM8DmM4 WiyIhAoLNQl1ehIToqMgcEbAiVUW8podxUmHCARYf322ZfelCRfCAfj/hdj7ggIuSy0g 5dBpKXQHri6klqfW6LZRlu9TxdIKDL7vJe6OJwCFKiKkQHI0mJuPuZ+4uiXb68+G1mFN WfNA8Kzupquq5EN5mlEv+KLItJLMPMhRPfaEqPWlVBGSM5ZgbU3o4eimvvl/yDqjhY80 Ot66uhZLg2sDoxRjTVAcGwBWXE6zDUPtqqdL9r1JY8ln635exINPaDVo4kbyrHxtDHtI aYVA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=fbfeNOM8iyPyr+TWupTSBMnZFBTZrlJzO74OghBIzos=; fh=w8jyaHKADhDb/sJN3O832LSqMsbDSxruIHc+RpWApf8=; b=MgCkY7S1Z8+3t+XLfXEI6o8Phpf6o66v0P9x3iJMcuUq7HDsxjkQC7Iir5Qg3AFqi7 hpT9eoG83DUpLNs8fHK4oSXc06wW+3sRsdb24rE3NbKRC7MpNl1rscVhM6ZI8glOVBN7 j8V/7mHDF6wTlu7dDqIGVsxbwXbsAHPG2JI5Mz2HSONFrkmQ0EqZ7d01ixc2UR9XL+2T as2V53LqL3vP7jltUPicbp7rYU4jJ4HfZmpWOopGCAGMcDf/LxO4VkGaIUN7CjlH8QO2 /r6JQbbc/xJ9UFxHi5wu4YpRH4pHxu7/KZWEH4pGhYSX9Ih6bOm/NTfpv9+QkeiPvrf1 iOtQ==; darn=postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=percona.com; s=google; t=1770389352; x=1770994152; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=fbfeNOM8iyPyr+TWupTSBMnZFBTZrlJzO74OghBIzos=; b=dP8o+h2BjoszvwrHngyTnDOnQBS7zK+MJRm+mic9ugOPaoGKPWQkdr/rFKZWcDtHpm SP3fLYSFlevY1dVs+swf+Cut8K2wW1tageIATCqF3jDgVNkTsvf2fbIavTsSOyAlIUNt UWM9zptLmN+3p2OkkqMzGOJJOSZ+Ij9lPOI8w= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1770389352; x=1770994152; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=fbfeNOM8iyPyr+TWupTSBMnZFBTZrlJzO74OghBIzos=; b=D1wAb7qzcBDsErNowZVEyP7YwvkvD1jFkX6iwlcwnph5PKuGkqFoh1CdAtrllraAOJ As7yIymMa9MtXFRhllOHe67xNU2QE4ibYHhxhIz8sBazkZ8qR3JlzHw9hzM/2t+xhjXK k1/0hQvDZQaVpBhrtoAuE2OmuvuUascTUxyyM3i8ygHQD663h2s8BUD4xloGnOgqVwD9 q3Nh/aK4TUl/ZOVtxcboerEmdoXhNQX1lmEv4WDWM4r+me9QubnIxlq0MG7LG61ITpGc Ofwv2aJoZSm6dN+UPf+0Gd5tG7Cwmb7ugk193r8HI8qwCcYyDHK+gRzJOgoau6x9SSpP rE1Q== X-Forwarded-Encrypted: i=1; AJvYcCUmKsofEC6TLwIPIkV5WVDGhC3ofcIYMT07M2kMvxqV9qjyw/m5hzOxwZwM3l9GPsV/jEeYwmuiREh5UOHY@postgresql.org X-Gm-Message-State: AOJu0YyWJwS5zzjY/rrVgTR9t++e7AR371RlqFymqs2i4S/CDThl5LlA Bt7sGRu04JkYU4yBj4yqyoyoIyrlpdupG88qhULYi8lWnYrGfKh5vgTTYp5E7uTZ35RpLQgLH28 N7oZmX1x74TUKSVefWZFtxdnfIEMPSEHqyXaw6gpQorZ7cbJ6XWAVGQUV+QoC8h0yegZ1yb0zPb +axolXc7LV+k97Evz0xzmD24nYyYnmtyQhCsXvH2DE75PMNRAeweJQAxSeMynxs+pSLupAn0f1J EZZakTuGxnEADeRB2EXJubUTyEKhtjoXBa1Qyiv0zU0dplRdMc= X-Gm-Gg: AZuq6aIsvoT0AMs7FnneIXKfjCc+1hQH6cUqmYocg70b81PHP0hVutyCwzEE3lhlsHZ vGdBoXNp1NTa/EpXuRywYdH9LKTPxOKtQtkAESi/uocHKFrQx0jl42pi144IfgRL+Rg8XIJzSSK hKpCaP8gteAKXCd+y7+nqQPlLQO44fHBdJuxz62AmLgE24Bn0gff5Td9TwyvqRF9NITNq4KtJsH EzKRkAJI+4Dgxeye8mRqZ6W0AEZKwleispz4eeRpvL7L9wscAbUNjSPmHv2rTeje3v5/gJFTWMi aw0raJX0l00pypwnkCc/svDN0iNDLVad+NDiCN9zggLz6SRnD7PtG1CL X-Received: by 2002:a05:690c:f02:b0:794:b7f1:59f1 with SMTP id 00721157ae682-7952ab7f283mr27322107b3.66.1770389352255; Fri, 06 Feb 2026 06:49:12 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Zsolt Parragi Date: Fri, 6 Feb 2026 14:49:01 +0000 X-Gm-Features: AZwV_QjHiDh9Ryt6OlskpqoaJHDUQqwBAyIDJ5DrR1kZ6HXevenTl76w11Qg-ec Message-ID: Subject: Re: CREATE TABLE LIKE INCLUDING TRIGGERS To: jian he Cc: Andrey Borodin , PostgreSQL-development Content-Type: text/plain; charset="UTF-8" X-CLOUD-SEC-AV-Sent: true X-CLOUD-SEC-AV-Info: percona,google_mail,monitor X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This looks good to me, I only have two minor comments: 1. The test should drop main_table1 and some_t1 2. there's a missing word in a comment (do -> to do) + char *trigcomment; /* comment to apply to trigger, or NULL */ + bool transformed; /* true means no need do parse analysis for * + * whenClause */