Re: Duplicate data even with primary keys enabled

Hello Scott,

I am wondering how the query matters here?

Also, I am just running a simple select from "TEST" with COL1, COL2, COL3
in the WHERE condition.
select * from 'TEST" WHERE COL1='3456' AND COL2='76542' AND COL3='5';

The actual Issue is I am unable to figure out why the table is having
duplicate data in the primary key columns. Or how postgres accepted 2 rows
with the same combination of the columns in the primary key constraint. I
would expect it to throw primary key constraint violation error.

Regards,
Teja. J.

On Fri, Oct 28, 2022 at 1:27 PM Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
wrote:

> > 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?
>
>