Re: BUG #15784: logical replication replicate data of type array foroperation insert but update/delete/truncate

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: BUG #15784: logical replication replicate data of type array foroperation insert but update/delete/truncate
Дата
Msg-id CAMkU=1y+jMzif-8Uh9w_o-7E_GrhekX-xLgGMvk4XMvc2BLQ3w@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #15784: logical replication replicate data of type array for operation insert but update/delete/truncate  (PG Bug reporting form <noreply@postgresql.org>)
Список 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 по дате отправления:

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #15784: logical replication replicate data of type array for operation insert but update/delete/truncate
Следующее
От: Amit Langote
Дата:
Сообщение: Re: BUG #15779: Partition elimination doesn't work as expected whenusing PARTITION BY RANGE