Unique key constraint Issue - Mailing list pgsql-general

From shashidhar Reddy
Subject Unique key constraint Issue
Date
Msg-id CAH=zU4t3KRpt6uTZn_4eKkvpL_X9ACGNZ+XDxfMjnn6ovAyPVQ@mail.gmail.com
Whole thread Raw
Responses Re: Unique key constraint Issue
Re: Unique key constraint Issue
List pgsql-general
Hello,

We have postgresql servers with PostgreSQL 13.10   on Ubuntu release 22.04.

The issue is a unique key constraint with two columns one is character another is integer. At some point the unique key did not work as I see duplicate values with these two columns combination and it happened on multiple servers on multiple databases on same table with same unique key. I tried db dump and restore but the key is failing to create when restore with duplicate value errors.



pgsql-general by date:

Previous
From: Shaun Robinson
Date:
Subject: Error creating materialized view
Next
From: ajit wangkhem
Date:
Subject: Re: Unique key constraint Issue