On Sun, Apr 28, 2019 at 2:48 AM PG Bug reporting form <
noreply(at)postgresql(dot)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