[HACKERS] Logical replication failing when foreign key present

Поиск
Список
Период
Сортировка
От Thom Brown
Тема [HACKERS] Logical replication failing when foreign key present
Дата
Msg-id CAA-aLv5WRQbfxdR_ha=tR_ghuS00pezr1ymia6WNMeO7hUDeLQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: [HACKERS] Logical replication failing when foreign key present  (Petr Jelinek <petr.jelinek@2ndquadrant.com>)
Список pgsql-hackers
Hi,

There's an issue which I haven't seen documented as expected
behaviour, where replicating data to a table which has a foreign key
results in a replication failure.  This produces the following log
entries:

LOG:  starting logical replication worker for subscription "contacts_sub"
LOG:  logical replication apply for subscription "contacts_sub" has started
ERROR:  AfterTriggerSaveEvent() called outside of query
LOG:  worker process: logical replication worker for subscription
16408 (PID 19201) exited with exit code 1


Reproducible test case:

On both instances:
 CREATE TABLE b (bid int PRIMARY KEY); CREATE TABLE a (id int PRIMARY KEY, bid int REFERENCES b (bid)); INSERT INTO b
(bid)VALUES (1);
 

First instance: CREATE PUBLICATION a_pub FOR TABLE a;

Second instance: CREATE SUBSCRIPTION a_sub CONNECTION 'host=127.0.0.1 port=5530
user=thom dbname=postgres' PUBLICATION a_pub;

First instance:INSERT INTO a (id, bid) VALUES (1,1);


Regards

Thom



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: [HACKERS] new autovacuum criterion for visible pages
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] PATCH: recursive json_populate_record()