Re: Duplicate data even with primary keys enabled - Mailing list pgsql-admin

From Scott Ribe
Subject Re: Duplicate data even with primary keys enabled
Date
Msg-id 032E52B8-00C2-431D-BBAF-DCFCCEA817D2@elevated-dev.com
Whole thread Raw
In response to Re: Duplicate data even with primary keys enabled  (Teju Jakkidi vlogs <teja.jakkidi05@gmail.com>)
Responses Re: Duplicate data even with primary keys enabled  (Teju Jakkidi vlogs <teja.jakkidi05@gmail.com>)
List pgsql-admin
> On Oct 28, 2022, at 2:15 PM, Teju Jakkidi vlogs <teja.jakkidi05@gmail.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
hasexactly same combination for those 3 rows. 

What query are you running?




pgsql-admin by date:

Previous
From: Teju Jakkidi vlogs
Date:
Subject: Re: Duplicate data even with primary keys enabled
Next
From: Teju Jakkidi vlogs
Date:
Subject: Re: Duplicate data even with primary keys enabled