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.