Feedback-ID: ie0a040ee:Fastmail
Message-ID: <eaf5d324-713f-4075-970b-989c5edea00a@eisentraut.org>
Date: Wed, 5 Nov 2025 14:01:16 +0100
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: CREATE TABLE ... LIKE INCLUDING ALL does not create new sequences
 for serial columns
To: Kumaresan Balakrishnan <kumaresan.balakrishnan@intics.ai>,
 "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Cc: Janarthanan Poornavel <jana@intics.ai>,
 Sivadhas arumugam <sivadhas.arumugam@intics.ai>,
 Intics Devops <intics.devops@intics.ai>
References: 
 <PN1PPF4D94C7838D296E7117862D95C7F5985C7A@PN1PPF4D94C7838.INDPRD01.PROD.OUTLOOK.COM>
Content-Language: en-US
From: Peter Eisentraut <peter@eisentraut.org>
In-Reply-To: 
 <PN1PPF4D94C7838D296E7117862D95C7F5985C7A@PN1PPF4D94C7838.INDPRD01.PROD.OUTLOOK.COM>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/eaf5d324-713f-4075-970b-989c5edea00a%40eisentraut.org>
Precedence: bulk

On 03.11.25 18:10, Kumaresan Balakrishnan wrote:
> This behavior occurs even with `INCLUDING ALL`, which implies `INCLUDING 
> DEFAULTS`
> and `INCLUDING IDENTITY`.  However, it seems that when serial columns 
> are used,
> their associated sequences are copied by reference rather than duplicated.

This works correctly if you use GENERATED ALWAYS AS IDENTITY instead of 
serial.

Using serial is kind of deprecated for reasons like this.