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 1wS7N5-002xvN-2V for pgsql-hackers@arkaria.postgresql.org; Wed, 27 May 2026 06:04:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wS7N3-007I7E-22 for pgsql-hackers@arkaria.postgresql.org; Wed, 27 May 2026 06:04:02 +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 1wS7N3-007I75-13 for pgsql-hackers@lists.postgresql.org; Wed, 27 May 2026 06:04:02 +0000 Received: from mail-dy1-x1344.google.com ([2607:f8b0:4864:20::1344]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wS7N2-00000000yKL-2odR for pgsql-hackers@postgresql.org; Wed, 27 May 2026 06:04:01 +0000 Received: by mail-dy1-x1344.google.com with SMTP id 5a478bee46e88-2f0ad52830cso14454060eec.1 for ; Tue, 26 May 2026 23:04:00 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1779861839; cv=none; d=google.com; s=arc-20240605; b=Ngtyidx6trAbXARNnjAhniGxOUZB6yVZ6bUcqLAPkkA1sCeaiTePIyjJ5ScSMvUpkD jcuS1DE9tEwGq4FE76uLdSVqEvv3nJpbb1g9gpXyoqA9EkObuX06SeQcmAqJtE+3U/Rt AhRMOCISTxrm1sirKC2TsfVXFPCQY/g+AX2bzZBbrTnjGhZcUo5j624Gl85uRD8RlkZL p461xSKdWP8i5ZN32K5IwR9BA8HuA0EmFI14OO5vEvD8OxztptqFZ3KCEEW190b2Zq7w lriQyQSNGfNhpIkFwcGetSYCPrXVpAbr82r0H4epwJGAnHtTm92Amr5oFf+kQW2uysFS CXPg== 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=F9Rx0zYxTfHakQ33ARB+zea6HqSeYGlkd89Rl2KAEcw=; fh=iRnjhQ5K5IeY8+o5dH8KOxuKBSilnNV6q++2SnhlQSI=; b=B0m+qxG6NtASl6t9f/IQsPgAzZU7zhrXC/ktfqmLZ64evcLUX8wMHCW8Wic3a+hgRb igh6PULKKpOucCR+O9buLXLhV/maWvTXIEud8IBGcStK3M/jjvcYSufH3eiV3mj0Ug+D v5yKT45yQuRVLKvz0HRx9VanB9s1rkGtQ2ZjhNAb+kyYsyUySIo6aclmM1emrY0/iW6F UTiBaq9D+CI2FdaMeS8LNoRfz/QbpQnncWz/fliwJ4FYtAPYbO8qpj4X2SB+T50Mvd8T p7hw61PrYZe8VU++S/Ys4SBEtPDSz34JDFh6/Rsuswbe15va8R6l02d/v93Ejznyzpe1 KsLg==; darn=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=1779861839; x=1780466639; 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=F9Rx0zYxTfHakQ33ARB+zea6HqSeYGlkd89Rl2KAEcw=; b=sQKcuDxmRSXX3/DfrsUtLwIBV6bDDyhhKec4t5D7kySg0D81Lsv/3u5hZGwtvVpcp2 apHrrpYS/EJ2JTG/gVeJu8o3SXPrl/jQrFdjRlGclbT4amr5dXyPHX5NItUnEdgGpDUm 3OxTe9l5GbWI35bY6+lF1bqWLI631SfIdCA1QyGZ8C5avIfBIzhZlC0xxx6EdpXo2DTK 2+2aTlWSaOPi3SNdxAvcFpRCstUNMaf2nbLHeJ3tRy3HKXrYNNI1Gfi5YrLcNr2JOEvk BflYPMwPAFlsqDR6HsZJQXkiByCKM1/PtYpbL0IDDwj8bRws7E6MShdH/IcUsgBFqmlr YuOA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1779861839; x=1780466639; 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=F9Rx0zYxTfHakQ33ARB+zea6HqSeYGlkd89Rl2KAEcw=; b=Btb3u/Ewu9wp2HYAtX1UGntwPxJF69LJUQmFsfD8rSsD4+Cw0wbMybtKDkq0BZuKec 0pRuk29jJue86XaGL93J/HwmLAosnNCrd/UbH6f/sMF8X3wIfO7OEMnZR/jcLzdwSvcG Jg+wNQM2stnxhZ9N2W15hTwg6m+iIBiCon6TcT/RKsQQPBwCcqAaI1+nmWeoc102s6sQ ouNWT74YmwdzM/fLyzr9uYA2+c7tCKuRgYv199XoobHxkME7bVAmnY1XOz989BSLf+sB sjNT4i8gDip0BNjUa//oryMPBw7IgZKgXFJsioFty1nQNL6E18UhVXrCGYnjQ01oetqk DG3w== X-Forwarded-Encrypted: i=1; AFNElJ9N0TasmVEd9ghxCYCW4q5chpsrqKEO2JdPnyByI/ZW/jT2Fd52/24j1LqYuabTRSVOXuUhSiw7qADWwA+a@postgresql.org X-Gm-Message-State: AOJu0YyV2oRZwy0OaEy7AeAe+kIRGR/M+P9fKliznpxmhGMp4NV25uNO Zp1iQcoIwsnBYE+8mxmcpEsefoEIwVM0sbuO8S6Bxg8ZiL7WPcTU+PwCKsPW7d8k4Q52yIm3jgg dxkSUBSJLaLq/wvbPmMlGK//aIyIbgOQ= X-Gm-Gg: Acq92OF+QvhK74r+BRUACQxGP0r0RYWR3chhw0jGtEY/jZu9VZnPLx8JrzoZo1w6k0C cONvmJxGgEb8/Kb08+2sDi2x1e08bQ8TZQZpRyPPHk30eDSMuZFTLQzy8oQ64YDyC5ZF9b5+MiR Cn//ZD5xex+QuCon7wxf3pIONzpoNT4zpX5oh1+tvxwCLp3kHR5PfewE+VOw7URYYbRZRK+eVQt L4ZsYQZa8f6yD3hhFapPuKs38XVQ3diy0FVkcaPvrU2Ogzoy99miR8YAJ2l3VfAo+z1HFnfZAvB af2K9+W8OFLMgrbUlg== X-Received: by 2002:a05:7300:134a:b0:2ed:a64:a457 with SMTP id 5a478bee46e88-30449184cbcmr10119851eec.20.1779861839469; Tue, 26 May 2026 23:03:59 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: lakshmi Date: Wed, 27 May 2026 11:33:29 +0530 X-Gm-Features: AVHnY4LMKa2HQTbIcvVV9rlRm8rXkYmrLtoMXKTEl9zEolniaScaoJV3S8iRnSo Message-ID: Subject: Re: CREATE TABLE LIKE INCLUDING TRIGGERS To: jian he Cc: Zsolt Parragi , Andrey Borodin , PostgreSQL-development Content-Type: multipart/alternative; boundary="000000000000b0de8c0652c6600c" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000b0de8c0652c6600c Content-Type: text/plain; charset="UTF-8" > > Hi Jian, > > I applied the latest v9 patches on current master and tested them locally. > > The patches applied cleanly, PostgreSQL built successfully. > > I also did some manual testing for INCLUDING TRIGGERS. Trigger definitions > were copied correctly to the new table, and the trigger enabled/disabled > state (tgenabled) was also preserved properly after applying the second > patch. > > Everything worked as expected in my testing. > > Thanks for working on this feature. > > Regards, > Lakshmi G > --000000000000b0de8c0652c6600c Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

H= i Jian,

I applied the latest v9 patches= on current master and tested them locally.

The patches applied cleanly, PostgreSQL built successfully.

I also did some manual testing for INCLUDING TRIG= GERS. Trigger definitions were copied correctly to the new table, and the t= rigger enabled/disabled state (tgenabled) was also preserved properly after= applying the second patch.

Everything = worked as expected in my testing.

Thank= s for working on this feature.

Regards,
Lakshmi G

--000000000000b0de8c0652c6600c--