Thread: Logical Replication - Different Primary Key on Source Table and Destination Table

Logical Replication - Different Primary Key on Source Table and Destination Table

From

Avi Weinberg

Date:

05 August 2021, 07:22:31

I use logical replication to copy data from many source tables to one destination table. On destination table I would like to have primary key composed of the source site ID and row ID. On the source table I only need the primary key to be the row ID since the site ID is always the same per site. Is it permitted to have different primary key on source and destination tables?

Thanks

IMPORTANT - This email and any attachments is intended for the above named addressee(s), and may contain information which is confidential or privileged. If you are not the intended recipient, please inform the sender immediately and delete this email: you should not copy or use this e-mail for any purpose nor disclose its contents to any person.

Re: Logical Replication - Different Primary Key on Source Table and Destination Table

From

"David G. Johnston"

Date:

05 August 2021, 15:42:27

On Thu, Aug 5, 2021 at 12:22 AM Avi Weinberg <AviW@gilat.com> wrote:

Is it permitted to have different primary key on source and destination tables?

Sure, but you are still going to want a unique index on the source table that includes the site ID to act as a replica identity. Which of the two unique indexes is "primary" is largely immaterial.

David J.