Request a Demo
Home   >   mailing lists

Re: BUG #19013: When creating a table with the "...LIKE...INCLUDING ALL" construct, REPLICA IDENTITY output is wrong - Mailing list pgsql-bugs

From dbman@sqlexec.com
Subject Re: BUG #19013: When creating a table with the "...LIKE...INCLUDING ALL" construct, REPLICA IDENTITY output is wrong
Date
Msg-id d20acac8-5cc1-43ba-9228-5c260de3796f@sqlexec.com
Whole thread Raw
In response to Re: BUG #19013: When creating a table with the "...LIKE...INCLUDING ALL" construct, REPLICA IDENTITY output is wrong  (Kirill Reshke <reshkekirill@gmail.com>)
List pgsql-bugs
Tree view 
On 8/6/2025 12:32 PM, Kirill Reshke wrote:
> It's hard (to me, at least) to say what is `intended` DDL here.

Why is it hard?  If the pg_dump output or /d schema.tablename output
indicates a REPLICA IDENTITY of either FULL or INDEX, then it seems it
should be obvious that the CREATE TABLE ... LIKE output should be
similar, but instead it will show REPLICA IDENTITY DEFAULT.

Regards,

Michael V

pgsql-bugs by date:

Previous
From: Kirill Reshke
Date:
Subject: Re: BUG #19013: When creating a table with the "...LIKE...INCLUDING ALL" construct, REPLICA IDENTITY output is wrong
Next
From: Álvaro Herrera
Date:
Subject: Re: BUG #19013: When creating a table with the "...LIKE...INCLUDING ALL" construct, REPLICA IDENTITY output is wrong