Re: Logical replication without a Primary Key

On Thu, Dec 7, 2017 at 2:53 PM, Chapman Flack <chap(at)anastigmatix(dot)net> wrote:
> On 12/07/2017 02:38 PM, Joshua D. Drake wrote:
>> A B C
>> foo,bar,baz
>> foo,bar,baz
>>
>> And then I say:
>>
>> UPDATE test set A = 1 where C = baz
>>
>> I have updated two rows because there is no primary key to identify the
>> differences. Both of those rows should be updated and thus replicated
>
> Would the subscriber see two records reporting update of a
> foo,bar,baz row to 1, so it would do that to (arbitrarily)
> one of them the first time, and (necessarily) the other, the
> second time?

Exactly.

(I think.)

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company