Re: Logical replication

From: Yambu <hyambu(at)gmail(dot)com>
To: Holger Jakobs <holger(at)jakobs(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Logical replication
Date: 2020-11-19 21:14:17
Message-ID: CALhHtcDpGL1GLKgf3uFGxawBEBKvWVkAt-nd5D93s3Hdb9g5Qw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Oh yes i meant primary key.

Thanks

On Thu, Nov 19, 2020 at 10:46 PM Holger Jakobs <holger(at)jakobs(dot)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(at)gmail(dot)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
>
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Michel SALAIS 2020-11-19 22:31:59 RE: select locks table for updates
Previous Message Simon Riggs 2020-11-19 21:13:30 Re: select locks table for updates