Re: Unique key constraint Issue

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: shashidhar Reddy <shashidharreddy001(at)gmail(dot)com>, ajit wangkhem <ajit(dot)wangkhem(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Unique key constraint Issue
Date: 2024-11-25 16:00:04
Message-ID: 42ed36a1-2581-43f7-a606-2c139929b38f@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 11/25/24 00:44, shashidhar Reddy wrote:
> Hi Ajit,
>
> Thank you for your reply!
>
> The result of the query is same across all servers and yes streaming
> replication does not have any issue but the question is how did
> duplicate values entered when there unique key in place.

Corrupted index?

Have you tried doing a REINDEX?

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2024-11-25 16:02:38 Re: Unique key constraint Issue
Previous Message Laurenz Albe 2024-11-25 12:54:45 Re: Error creating materialized view