Re: How to discover what table is - Mailing list pgsql-general

From Ron
Subject Re: How to discover what table is
Date
Msg-id 43b445af-270e-813e-76b5-01578f635b56@gmail.com
Whole thread Raw
In response to How to discover what table is  (PegoraroF10 <marcos@f10.com.br>)
Responses Re: How to discover what table is  (PegoraroF10 <marcos@f10.com.br>)
List pgsql-general
On 3/8/20 12:26 PM, PegoraroF10 wrote:
I have a publication/subscription replication.
Then this week started to see this message on Log of replica server.

Message is "duplicate key value violates unique constraint "pksyslookup""
Detail is "Key (lookup_id)=(56) already exists." 

and on production server message is
"logical decoding found consistent point at 5D5/5CD64ED0"


I have 200 schemas on that database and every schema has that table, so ho
can I discover what table is having that violation ? 

Are you asking which schema it's in?

--
Angular momentum makes the world go 'round.

pgsql-general by date:

Previous
From: PegoraroF10
Date:
Subject: How to discover what table is
Next
From: PegoraroF10
Date:
Subject: Re: How to discover what table is