Postgres Pro
Downloads
Home   >   mailing lists

Re: Logical replication - Mailing list pgsql-admin

From Yambu
Subject Re: Logical replication
Date
Msg-id CALhHtcDpGL1GLKgf3uFGxawBEBKvWVkAt-nd5D93s3Hdb9g5Qw@mail.gmail.com
Whole thread Raw
In response to Re: Logical replication  (Holger Jakobs <holger@jakobs.com>)
List pgsql-admin
Tree view
Oh yes i meant primary key.

Thanks

On Thu, Nov 19, 2020 at 10:46 PM Holger Jakobs <holger@jakobs.com> wrote:

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

pgsql-admin by date:

Previous
From: Simon Riggs
Date:
Subject: Re: select locks table for updates
Next
From: "Michel SALAIS"
Date:
Subject: RE: select locks table for updates