Обсуждение: Logical replication

Поиск
Список
Период
Сортировка

Logical replication

От
Yambu
Дата:
Hello

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

regards

Re: Logical replication

От
"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.

Re: Logical replication

От
Holger Jakobs
Дата:

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
Вложения

Re: Logical replication

От
Yambu
Дата:
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