On Thu, Aug 5, 2021 at 12:22 AM Avi Weinberg 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 inde
Hi
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 pe
