Logical Replication - Different Primary Key on Source Table and Destination Table - Mailing list pgsql-general

From Avi Weinberg
Subject Logical Replication - Different Primary Key on Source Table and Destination Table
Date
Msg-id DB9PR07MB7180BA37AF3D17E57CDEFA36CBF29@DB9PR07MB7180.eurprd07.prod.outlook.com
Whole thread Raw
Responses Re: Logical Replication - Different Primary Key on Source Table and Destination Table  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general

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 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.

pgsql-general by date:

Previous
From: Luca Ferrari
Date:
Subject: autovacuum worker started without a worker entry
Next
From: Laura Smith
Date:
Subject: PostgreSQL Apt Repository instructions need updating