Horton

Re: CREATE TABLE ... LIKE INCLUDING ALL does not create new sequences for serial columns

Peter Eisentraut <peter@eisentraut.org>

View thread
From: Peter Eisentraut <peter@eisentraut.org>
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>
Date: 2025-11-05T13:01:16Z
Lists: pgsql-bugs 
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.