Re: Duplicate data even with primary keys enabled

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: jwiencek3 <jwiencek3(at)comcast(dot)net>
Cc: Teju Jakkidi vlogs <teja(dot)jakkidi05(at)gmail(dot)com>, Samed YILDIRIM <samed(at)reddoc(dot)net>, Holger Jakobs <holger(at)jakobs(dot)com>, pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Duplicate data even with primary keys enabled
Date: 2022-10-31 17:19:14
Message-ID: 751E945F-B11B-4A34-AE93-63046AF3D26A@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> On Oct 31, 2022, at 11:08 AM, jwiencek3 <jwiencek3(at)comcast(dot)net> wrote:
>
> Have you tried dropping the index and then recreating it ?

Recreate or reindex are good things to try. BUT DEFINITELY CHECK INDEX DEFINITION BEFORE DROPPING

Browse pgsql-admin by date

  From Date Subject
Next Message abbas alizadeh 2022-11-01 03:53:53 Pg_upgrade issue
Previous Message Scott Ribe 2022-10-31 16:16:00 Re: Duplicate data even with primary keys enabled