Identity/Serial Column In Subscriber's Tables

From: Avi Weinberg <AviW(at)gilat(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Identity/Serial Column In Subscriber's Tables
Date: 2021-12-09 09:13:53
Message-ID: DB9PR07MB7180BB8F0CFD28857B89B250CB709@DB9PR07MB7180.eurprd07.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Experts,

What is the best practice when dealing with Identity/Serial column in logical replication.
Should the subscriber table have this column also defined as Identity/Serial or have it defined as regular integer?
Is leaving it as Identity/Serial also on subscriber tables, can potentially cause a problem?

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shaozhong SHI 2021-12-09 11:03:19 Use tsquery to check out occurrence of the same phrase in a cell
Previous Message Дмитрий Иванов 2021-12-09 03:26:38 Re: CTE Materialization