From: Tom Lane <tgl@sss.pgh.pa.us>
To: Achilleas Mantzios <achill@matrix.gatewaynet.com>
cc: pgsql-admin@lists.postgresql.org
Subject: Re: Table's REPLICATE IDENTITY : where is it kept?
In-reply-to: <1e6cc5ad-b84a-7c07-8c08-a4d0c3cdc938@matrix.gatewaynet.com>
References: <1e6cc5ad-b84a-7c07-8c08-a4d0c3cdc938@matrix.gatewaynet.com>
Comments: In-reply-to Achilleas Mantzios <achill@matrix.gatewaynet.com>
	message dated "Mon, 30 Jul 2018 13:44:49 +0300"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <24601.1532957847.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Mon, 30 Jul 2018 09:37:27 -0400
Message-ID: <24602.1532957847@sss.pgh.pa.us>
Precedence: bulk

Achilleas Mantzios <achill@matrix.gatewaynet.com> writes:
> I noticed that after changing a table's REPLICA IDENTITY via the ALTER T=
ABLE command, this is not reflected in pg_dump.

Really?  There's certainly code in there that purports to do it:

    /*
     * dump properties we only have ALTER TABLE syntax for
     */
    if ((tbinfo->relkind =3D=3D RELKIND_RELATION ||
         tbinfo->relkind =3D=3D RELKIND_PARTITIONED_TABLE ||
         tbinfo->relkind =3D=3D RELKIND_MATVIEW) &&
        tbinfo->relreplident !=3D REPLICA_IDENTITY_DEFAULT)
    {
        if (tbinfo->relreplident =3D=3D REPLICA_IDENTITY_INDEX)
        {
            /* nothing to do, will be set when the index is dumped */
        }
        else if (tbinfo->relreplident =3D=3D REPLICA_IDENTITY_NOTHING)
        {
            appendPQExpBuffer(q, "\nALTER TABLE ONLY %s REPLICA IDENTITY N=
OTHING;\n",
                              qualrelname);
        }
        else if (tbinfo->relreplident =3D=3D REPLICA_IDENTITY_FULL)
        {
            appendPQExpBuffer(q, "\nALTER TABLE ONLY %s REPLICA IDENTITY F=
ULL;\n",
                              qualrelname);
        }
    }

			regards, tom lane