Re: Duplicate data even with primary keys enabled

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Teju Jakkidi vlogs <teja(dot)jakkidi05(at)gmail(dot)com>
Cc: Holger Jakobs <holger(at)jakobs(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Duplicate data even with primary keys enabled
Date: 2022-10-28 20:27:29
Message-ID: 032E52B8-00C2-431D-BBAF-DCFCCEA817D2@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> On Oct 28, 2022, at 2:15 PM, Teju Jakkidi vlogs <teja(dot)jakkidi05(at)gmail(dot)com> wrote:
>
> Also, the values that we are seeing is as below:
>
> COL1 COL2 COL3 COL4 COL5 COL6
> 1 3456 76542 5 ABC 1234
> 1 3456 76542 5 ABC 1234
> 2 9872 89765 0 FGT 1234
> 3 6547 78659 7 JHL 8790
>
> We already defined COL1, COL2, COL3 as primary keys, but still as you see above in the table output, the first 2 rows has exactly same combination for those 3 rows.

What query are you running?

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Teju Jakkidi vlogs 2022-10-28 20:42:06 Re: Duplicate data even with primary keys enabled
Previous Message Teju Jakkidi vlogs 2022-10-28 20:15:46 Re: Duplicate data even with primary keys enabled