better error description on logical replication

Поиск
Список
Период
Сортировка
От Marcos Pegoraro
Тема better error description on logical replication
Дата
Msg-id CAB-JLwaJcqniaPAfZuXTuHbfQb+Jh27bLZ05mJ-Hy=JRFgoLsw@mail.gmail.com
обсуждение исходный текст
Ответы Re: better error description on logical replication  (Amit Kapila <amit.kapila16@gmail.com>)
Список pgsql-hackers
I don´t know how to create a patch, maybe someday, but for now I´m just sending this little problem if somebody can solve it.

In a multi schema environment where several tables has same structure is a little bit hard to know which one already has that primary key.

On log I see now on replica server.
Message:duplicate key value violates unique constraint "pkcustomer"
Detail: Key (customer_id)=(530540) already exists.

So, I know what table is but I don´t know what schema it belongs.

Thanks 
Marcos

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

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: Support logical replication of DDLs
Следующее
От: Aleksander Alekseev
Дата:
Сообщение: Re: [PATCH] Compression dictionaries for JSONB