Logical replication without a Primary Key

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Logical replication without a Primary Key
Date: 2017-12-07 00:03:14
Message-ID: f698c340-0184-fa9d-daaf-d0dd33e610ab@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

-Hackers,

In the docs it says:

"
If the table does not have any suitable key, then it can be set to
replica identity“full”, which means the entire row becomes the key.

"

How does that work? Is it using one of the hidden columns on a row?

Thanks,

JD

--
Command Prompt, Inc. || http://the.postgres.company/ || @cmdpromptinc

PostgreSQL Centered full stack support, consulting and development.
Advocate: @amplifypostgres || Learn: https://pgconf.org
***** Unless otherwise stated, opinions are my own. *****

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Vitaliy Garnashevich 2017-12-07 00:17:13 Re: Bitmap scan is undercosted?
Previous Message Chapman Flack 2017-12-06 23:59:02 Re: Signals in a BGW