better error description on logical replication

From: Marcos Pegoraro <marcos(at)f10(dot)com(dot)br>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: better error description on logical replication
Date: 2022-06-28 12:19:36
Message-ID: CAB-JLwaJcqniaPAfZuXTuHbfQb+Jh27bLZ05mJ-Hy=JRFgoLsw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Aleksander Alekseev 2022-06-28 12:37:14 Re: [PATCH] Compression dictionaries for JSONB
Previous Message Amit Kapila 2022-06-28 12:13:44 Re: Support logical replication of DDLs