Re: Logical replication without a Primary Key - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Logical replication without a Primary Key
Date
Msg-id 617f32f9-1fab-ea7d-745c-f64d0ad902ec@2ndquadrant.com
Whole thread Raw
In response to Logical replication without a Primary Key  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: Logical replication without a Primary Key
Re: Logical replication without a Primary Key
List pgsql-hackers
On 12/6/17 19:03, Joshua D. Drake wrote:
> -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?

It means that for example if an update record is produced, the entire
row is included in the record as the key.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-hackers by date:

Previous
From: Alexander Korotkov
Date:
Subject: Re: compress method for spgist - 2
Next
From: Peter Eisentraut
Date:
Subject: Re: [HACKERS] logical decoding of two-phase transactions