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

From: "dbman(at)sqlexec(dot)com" <dbman(at)sqlexec(dot)com>
To: Kirill Reshke <reshkekirill(at)gmail(dot)com>
Cc: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #19013: When creating a table with the "...LIKE...INCLUDING ALL" construct, REPLICA IDENTITY output is wrong
Date: 2025-08-06 16:52:28
Message-ID: d20acac8-5cc1-43ba-9228-5c260de3796f@sqlexec.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Álvaro Herrera 2025-08-06 18:04:37 Re: BUG #19013: When creating a table with the "...LIKE...INCLUDING ALL" construct, REPLICA IDENTITY output is wrong
Previous Message Kirill Reshke 2025-08-06 16:32:59 Re: BUG #19013: When creating a table with the "...LIKE...INCLUDING ALL" construct, REPLICA IDENTITY output is wrong