Обсуждение: Logical Replication - Different Primary Key on Source Table and Destination Table

Поиск
Список
Период
Сортировка

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

От
Avi Weinberg
Дата:

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.

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

От
"David G. Johnston"
Дата:
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.

Сайт использует файлы cookie для корректной работы и повышения удобства. Нажимая кнопку «Принять» или продолжая пользоваться сайтом, вы соглашаетесь на их использование в соответствии с Политикой в отношении обработки cookie ООО «ППГ», в том числе на передачу данных из файлов cookie сторонним статистическим и рекламным службам. Вы можете управлять настройками cookie через параметры вашего браузера