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

From Kirill Reshke
Subject Re: BUG #19013: When creating a table with the "...LIKE...INCLUDING ALL" construct, REPLICA IDENTITY output is wrong
Date
Msg-id CALdSSPg1Y2UGAWRYOu3q5SLNYzw1T-U4m95SHyMW6k64+veyZw@mail.gmail.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  ("dbman@sqlexec.com" <dbman@sqlexec.com>)
Responses Re: BUG #19013: When creating a table with the "...LIKE...INCLUDING ALL" construct, REPLICA IDENTITY output is wrong
List pgsql-bugs
Hi!

On Wed, 6 Aug 2025 at 20:42, dbman@sqlexec.com <dbman@sqlexec.com> wrote:
> Good point aboutg the default value for pg_class.relreplident is always "d", but maybe it should be "n" which
indicatesthere is no REPLICA IDENTITY.
 
So, in other words, you propose to change the default behaviour?

> Othewise you have an unintended DDL change consequence to this action.

It's hard (to me, at least) to say what is `intended` DDL here.

> Perhaps add a warning about this in the description for CREATE...LIKE in the docs, or even mention it in the section
thatdescribes REPLICA IDENTITY, or both.
 

Perhaps, rewording docs to indicate something like this does not sound
horribly to me.

-- 
Best regards,
Kirill Reshke



pgsql-bugs by date:

Previous
From: "dbman@sqlexec.com"
Date:
Subject: Re: BUG #19013: When creating a table with the "...LIKE...INCLUDING ALL" construct, REPLICA IDENTITY output is wrong
Next
From: "dbman@sqlexec.com"
Date:
Subject: Re: BUG #19013: When creating a table with the "...LIKE...INCLUDING ALL" construct, REPLICA IDENTITY output is wrong