Re: BUG #15784: logical replication replicate data of type array foroperation insert but update/delete/truncate - Mailing list pgsql-bugs

From Jeff Janes
Subject Re: BUG #15784: logical replication replicate data of type array foroperation insert but update/delete/truncate
Date
Msg-id CAMkU=1y+jMzif-8Uh9w_o-7E_GrhekX-xLgGMvk4XMvc2BLQ3w@mail.gmail.com
Whole thread Raw
In response to BUG #15784: logical replication replicate data of type array for operation insert but update/delete/truncate  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
On Sun, Apr 28, 2019 at 2:48 AM PG Bug reporting form <noreply@postgresql.org> wrote:
 
in subscriber
========
--2.create same table as in publisher
create table HA_LOGICAL_REPLICATION_TAB_005(id int, name text, array1
text[], array2 integer[3][3]);

Note that you did not declare "id" to be a primary key on the subscriber.

If you look in the subscriber log, you should find:

ERROR:  logical replication target relation "public.ha_logical_replication_tab_005" has neither REPLICA IDENTITY index nor PRIMARY KEY and published relation does not have REPLICA IDENTITY FULL

The array type is not relevant to the problem.

Cheers,

Jeff

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #15784: logical replication replicate data of type array for operation insert but update/delete/truncate
Next
From: Amit Langote
Date:
Subject: Re: BUG #15779: Partition elimination doesn't work as expected whenusing PARTITION BY RANGE