FYI - We tried logging in the issue through their JIRA which we weren't able to do. So, we have taken this route so far to at-least close the loop this way. We will keep you posted on next developments as we get more details.
From: Kumaresan Balakrishnan <kumaresan.balakrishnan@intics.ai>
Sent: 03 November 2025 22:40
To: pgsql-bugs@lists.postgresql.org
Cc: Janarthanan Poornavel <jana@intics.ai>; Sivadhas arumugam <sivadhas.arumugam@intics.ai>; Intics Devops <intics.devops@intics.ai>
Subject: CREATE TABLE ... LIKE INCLUDING ALL does not create new sequences for serial columns
I encountered an unexpected behavior when using the "CREATE TABLE ... LIKE ... INCLUDING ALL" syntax.
When a table is created this way from another table that contains serial or identity columns,
the new table’s column defaults still reference the *original* sequence objects from the source table,
rather than creating new independent sequences.
This results in both tables sharing the same sequence, which can cause data consistency issues
if inserts happen on both tables.
Tested on PostgreSQL 16.1 (Ubuntu 22.04, x86_64).
CREATE SCHEMA IF NOT EXISTS audit;
CREATE TABLE audit.statement_execution_audit (
2. Backup and recreate the table:
DROP TABLE IF EXISTS audit.statement_execution_audit_backup;
ALTER TABLE audit.statement_execution_audit
RENAME TO statement_execution_audit_backup;
CREATE TABLE audit.statement_execution_audit
(LIKE audit.statement_execution_audit_backup INCLUDING ALL);
\d audit.statement_execution_audit
The `id` column of the newly created table references the same sequence:
nextval('audit.statement_execution_audit_backup_id_seq'::regclass)
Ideally, the new table should receive its *own sequence* (for example,
`audit.statement_execution_audit_id_seq`), or there should be an option such as
`INCLUDING SEQUENCES` to explicitly request new sequence creation.
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.
If this is expected behavior, perhaps documentation could clarify that
`INCLUDING ALL` does not create new sequences for serial columns.
Thank you for your time and all your work maintaining PostgreSQL.
