From: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Logical replication
Date: Thu, 19 Nov 2020 21:46:19 +0100
Message-ID: <dc37e0ba-50de-a640-5da5-5e6591ff4e8b@jakobs.com> (raw)
In-Reply-To: <CAKFQuwbNEEh2O-Ygq0YOi3WzbKcaLfGJ3eaWsbF3KR7t8rwiDQ@mail.gmail.com>
References: <CALhHtcBVZCikCUxtT=-kxpw087B1wLn_E6cM=tQZN+DSYdLU4w@mail.gmail.com>
<CAKFQuwbNEEh2O-Ygq0YOi3WzbKcaLfGJ3eaWsbF3KR7t8rwiDQ@mail.gmail.com>
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
> <mailto: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
Attachments:
[application/pgp-keys] OpenPGP_0x8A579C93B31961BA.asc (16.5K, ../dc37e0ba-50de-a640-5da5-5e6591ff4e8b@jakobs.com/3-OpenPGP_0x8A579C93B31961BA.asc)
download
[application/pgp-signature] OpenPGP_signature (202B, ../dc37e0ba-50de-a640-5da5-5e6591ff4e8b@jakobs.com/4-OpenPGP_signature)
download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: holger@jakobs.com, pgsql-admin@lists.postgresql.org
Subject: Re: Logical replication
In-Reply-To: <dc37e0ba-50de-a640-5da5-5e6591ff4e8b@jakobs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox