Postgres Pro
Downloads
Home   >   mailing lists

Re: Logical replication - Mailing list pgsql-admin

From Holger Jakobs
Subject Re: Logical replication
Date
Msg-id dc37e0ba-50de-a640-5da5-5e6591ff4e8b@jakobs.com
Whole thread Raw
In response to Re: Logical replication  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Logical replication  (Yambu <hyambu@gmail.com>)
List pgsql-admin
Tree view

I think he refers to a table without a PRIMARY KEY.

No, that's not a good idea, as it is never a good idea having a table without a PRIMARY KEY.

PRIMARY KEYs are not an optional feature.

Am 19.11.20 um 21:40 schrieb David G. Johnston:
On Thu, Nov 19, 2020 at 1:39 PM Yambu <hyambu@gmail.com> wrote:
Is it recommended to do logical replication on a table without a primary?


primary what?

David J.

-- 
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
Attachment

pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Logical replication
Next
From: Simon Riggs
Date:
Subject: Re: select locks table for updates