Logical replication

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Logical replication

Yambu
Hello

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

regards
Reply | Threaded
Open this post in threaded view
|

Re: Logical replication

David G Johnston
On Thu, Nov 19, 2020 at 1:39 PM Yambu <[hidden email]> wrote:
Is it recommended to do logical replication on a table without a primary?


primary what?

David J.

Reply | Threaded
Open this post in threaded view
|

Re: Logical replication

Holger Jakobs-2

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 <[hidden email]> 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

OpenPGP_0x8A579C93B31961BA.asc (17K) Download Attachment
OpenPGP_signature (209 bytes) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: Logical replication

Yambu
Oh yes i meant primary key.

Thanks

On Thu, Nov 19, 2020 at 10:46 PM Holger Jakobs <[hidden email]> 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 <[hidden email]> 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