Postgres Pro
Downloads
Home   >   mailing lists

Thread: Logical replication

Logical replication

From
Yambu
Date:
Hello

Is it recommended to do logical replication on a table without a primary?

regards

Re: Logical replication

From
"David G. Johnston"
Date:
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.

Re: Logical replication

From
Holger Jakobs
Date:

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

Re: Logical replication

From
Yambu
Date:
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