Unique key constraint Issue

From: shashidhar Reddy <shashidharreddy001(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Unique key constraint Issue
Date: 2024-11-25 06:30:55
Message-ID: CAH=zU4t3KRpt6uTZn_4eKkvpL_X9ACGNZ+XDxfMjnn6ovAyPVQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message ajit wangkhem 2024-11-25 07:51:41 Re: Unique key constraint Issue
Previous Message Shaun Robinson 2024-11-25 06:08:16 Error creating materialized view