Content-Type: multipart/alternative;
 boundary="------------a4QnPmVQD0rpjxnmbHs3oW6D"
Message-ID: <fade757a-328a-46fc-a117-8d22459e35d7@sqlexec.com>
Date: Wed, 6 Aug 2025 07:56:53 -0400
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: BUG #19013: When creating a table with the "...LIKE...INCLUDING
 ALL" construct, REPLICA IDENTITY output is wrong
To: "David G. Johnston" <david.g.johnston@gmail.com>,
 pgsql-bugs@lists.postgresql.org
References: <19013-04a5827d56b97202@postgresql.org>
 <CAKFQuwba_gRmzi4C9Uu=_+AW8L-z=V0MpkPgk3HNBoKkfA09zA@mail.gmail.com>
Content-Language: en-US
From: "dbman@sqlexec.com" <dbman@sqlexec.com>
In-Reply-To: 
 <CAKFQuwba_gRmzi4C9Uu=_+AW8L-z=V0MpkPgk3HNBoKkfA09zA@mail.gmail.com>
UI-OutboundReport: notjunk:1;M01:P0:kgLPlghDdUU=;6pRXH7pmI4oRF+Zi/K4ScKt/lUU
 VHvzCxcQXDy/UEuLvKpzUsB2b77iaRJP++Fd2MHxUvbB8nXtqxSrc0VdrKPgrxaghFCh2dSoQ
 nahvNA1ZxZlbui+/Nx3uIL2MznENbEvn5iBc8RdK4xdmXNHTuZ+XJn3+SF29aBTMm6M40AfXZ
 F4ohnibrsHmLHdwE394DHZCuSuv85fzf97v/FAbVbcUC7k+10JOn0vwW/SDFb6MzhCtOsCFFQ
 mZzgMTINFnnMRyLw2fGXm/oOBgtc+LdQAlF3G8XVpPuI3yMh+B7PdLvAZez1jUUDmjHaAEtNu
 SbqbJyZPIM4CxVA023M3p9F4hqy1rfIMZsPlewn4AU9LmsVSM9LdHis3cvrsDDojB5CDfUb7B
 OX4Uo5TJeyzP8rESRQLHPz4fDzdbICjVL5Hs+Egomh1p/a8YtWEw+r3gH+O337oz7CFobRC74
 ozvEjRP3BLg/bDnHmHC9psRCu/POlKTrRfR9xhLxwMQ1OZwK24g3zOo98WCfa5c5GJ6vjDtJJ
 ebMWT8soQ7c7ZadBf9CQjskfYsgU9tPTZ9RaY23MbYjVX7o4INNd4Hr5LbFoLsCF9kBPZPcFS
 TtXz0kiqRzJckRfvRqekEEAEUYf0kzyyYaGW5e2gso2LIf8pSJY33NwKX3VDmf5x8R5hfsV7S
 3RlKxnHDEixiElciq9eXeOzZo7beO8k9VEfmQ6ktQ50GXI87b+HJ2IapKa+RiML+pR3bWJubU
 C+Ay/NrftEt4Euz8h8YGgX8nHFDoFqvafmI3vxHwWSBIOAVNa5D9OEWJVg/wvKcrJY/bttWK/
 sh2ZobXyZbpoDddSgzwJasKW67jugi8yBFKQfer7nqvsQahvVLP6oZo34kqBVf8rZEvUdy+Ur
 1mSS0kAIjhd8yda1GngoNAkYRCyqisq/9qxRv2mnub7QLf7ayUzy7taUhZy0ZlUL/dAmw0niD
 98u5Eum7gG6uiXUD7HklhI82n4UPY/bTVwZnODa3ioYfrD82T75eHkV60bx/Jq5olVZ7ryI/P
 d4H+JkpxSBWF1tEZATcP0uMGRT6+iqx3KdeaMzz5BiQPAn+XSKfzlPB/jqJJeyqzHM0ora0dg
 zSGodsF59ukHsqv7wKeHPImmoujO/gJYFKqq6V82fm1vdaonD64yFScIbdoNXFIhv3dopnWl4
 dJPLenPLqUECpiS7uhGCPihuIlGZmpKLVgOBEdC48tSspp34ahhhWQsPE7oJVKP8Jy418z9ve
 RLX1d/E7KCsdApOY+DkQUSRhMRhvTpKEHcOhno3qNgHG6KchmNBap6g3oGz7O2AEUD4ZWvkPx
 c5UH5KUNLVelbbiYmx52d57ocwuf3bPFdTC64/nYn6LEiS32Hn5VTXTiyMtJFNcv/8WeJTbjd
 3DzYUftEPdPuAvRmx2eOcJiBnIZ33++wcDOdTDYcg6I3WllXc6TXiOZXkTZ3unhEgaQNMu37r
 mbku/Qq8VbmTpKxy8WFjsN4w6ApfP83VYMqGDclnP7m3hHJ+oXeoQSSP5y4bVEDAYt+XE5LTO
 vInAGBdM4yhK8dRGJUL8Q+haF3hjqzmZzTSBrVW6/Uw/Ju5lkoK9jZGEi1dqA981M6gPJJv/d
 9z39zV3AzOzDFwQhmDMdpv3oByHHecoaECYKqonyQdc6GDBUwwVlg==
Archived-At: 
 <https://www.postgresql.org/message-id/fade757a-328a-46fc-a117-8d22459e35d7%40sqlexec.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------a4QnPmVQD0rpjxnmbHs3oW6D
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: quoted-printable

On 8/5/2025 7:01 PM, David G. Johnston wrote:
> On Tue, Aug 5, 2025 at 2:43=E2=80=AFPM PG Bug reporting form=20
> <noreply@postgresql.org> wrote:
>
>     The following bug has been logged on the website:
>
>     Bug reference:=C2=A0 =C2=A0 =C2=A0 19013
>     Logged by:=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 Michael Vitale
>     Email address: dbman@sqlexec.com
>     PostgreSQL version: 17.5
>     Operating system:=C2=A0 =C2=A0CentOS 8 Streams
>     Description:
>
>
> We don't document that the replica identity attribute of a table is=20
> something that can be copied.=C2=A0 'ALL' only covers those things which=
=20
> are documented as being copy-able.
>
> David J.
>
I understand your logic about not everything is copy-able, just what is=20
documented, but this is a different case.=C2=A0 I am not complaining that =
it=20
is not copying the REPLICA IDENTITY, but rather that it is copying it in=
=20
a WRONG WAY, changing its property from FULL to DEFAULT.=C2=A0 I think tha=
t=20
is a reasonable complaint.=C2=A0 If you are going to attempt to copy it=20
erroneously, then I think you should consider that a bug and fix it.=C2=A0=
=20
Otherwise, remove it and don't try to copy it.=C2=A0 Does that seem reason=
able?

--------------a4QnPmVQD0rpjxnmbHs3oW6D
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3DUTF-=
8">
  </head>
  <body>
    <div class=3D"moz-cite-prefix">On 8/5/2025 7:01 PM, David G. Johnston
      wrote:<br>
    </div>
    <blockquote type=3D"cite"
cite=3D"mid:CAKFQuwba_gRmzi4C9Uu=3D_+AW8L-z=3DV0MpkPgk3HNBoKkfA09zA@mail.g=
mail.com">
      <meta http-equiv=3D"content-type" content=3D"text/html; charset=3DUT=
F-8">
      <div dir=3D"ltr">
        <div dir=3D"ltr">
          <div class=3D"gmail_default"
            style=3D"font-family:arial,helvetica,sans-serif"><span
              style=3D"font-family:Arial,Helvetica,sans-serif">On Tue, Aug
              5, 2025 at 2:43=E2=80=AFPM PG Bug reporting form &lt;<a
                href=3D"mailto:noreply@postgresql.org"
                moz-do-not-send=3D"true" class=3D"moz-txt-link-freetext">n=
oreply@postgresql.org</a>&gt;
              wrote:</span></div>
        </div>
        <div class=3D"gmail_quote gmail_quote_container">
          <blockquote class=3D"gmail_quote"
style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);p=
adding-left:1ex">The
            following bug has been logged on the website:<br>
            <br>
            Bug reference:=C2=A0 =C2=A0 =C2=A0 19013<br>
            Logged by:=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 Michael Vitale<br=
>
            Email address:=C2=A0 =C2=A0 =C2=A0 <a href=3D"mailto:dbman@sql=
exec.com"
              target=3D"_blank" moz-do-not-send=3D"true"
              class=3D"moz-txt-link-freetext">dbman@sqlexec.com</a><br>
            PostgreSQL version: 17.5<br>
            Operating system:=C2=A0 =C2=A0CentOS 8 Streams<br>
            Description:=C2=A0 =C2=A0 =C2=A0 =C2=A0 <br>
            <br>
          </blockquote>
          <div><br>
          </div>
          <div>
            <div class=3D"gmail_default"
              style=3D"font-family:arial,helvetica,sans-serif">We don't
              document that the replica identity attribute of a table is
              something that can be copied.=C2=A0 'ALL' only covers those
              things which are documented as being copy-able.</div>
            <div class=3D"gmail_default"
              style=3D"font-family:arial,helvetica,sans-serif"><br>
            </div>
            <div class=3D"gmail_default"
              style=3D"font-family:arial,helvetica,sans-serif">David J.</d=
iv>
          </div>
          <div class=3D"gmail_default"
            style=3D"font-family:arial,helvetica,sans-serif"><br>
          </div>
        </div>
      </div>
    </blockquote>
    <p>I understand your logic about not everything is copy-able, just
      what is documented, but this is a different case.=C2=A0 I am not
      complaining that it is not copying the REPLICA IDENTITY, but
      rather that it is copying it in a WRONG WAY, changing its property
      from FULL to DEFAULT.=C2=A0 I think that is a reasonable complaint.=
=C2=A0 If
      you are going to attempt to copy it erroneously, then I think you
      should consider that a bug and fix it.=C2=A0 Otherwise, remove it an=
d
      don't try to copy it.=C2=A0 Does that seem reasonable?</p>
  </body>
</html>

--------------a4QnPmVQD0rpjxnmbHs3oW6D--