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

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Logical Replication - Different Primary Key on Source Table and Destination Table
Дата
Msg-id CAKFQuwYKqk9W_M1L8HsJuV7J4_OYLXcU2WMFxjovTVkE50_NXA@mail.gmail.com
обсуждение исходный текст
Ответ на Logical Replication - Different Primary Key on Source Table and Destination Table  (Avi Weinberg <AviW@gilat.com>)
Список pgsql-general
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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Laura Smith
Дата:
Сообщение: PostgreSQL Apt Repository instructions need updating
Следующее
От: Vijaykumar Jain
Дата:
Сообщение: Re: autovacuum worker started without a worker entry