Re: Duplicate data even with primary keys enabled
| От | Teju Jakkidi vlogs |
|---|---|
| Тема | Re: Duplicate data even with primary keys enabled |
| Дата | |
| Msg-id | CAKA2XvYoEw0qbMKmnk686gOKe+FrR22R14S6Ts1aY96+ExHtgA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Duplicate data even with primary keys enabled (Scott Ribe <scott_ribe@elevated-dev.com>) |
| Ответы |
Re: Duplicate data even with primary keys enabled
Re: Duplicate data even with primary keys enabled |
| Список | pgsql-admin |
Hello Scott,
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@elevated-dev.com> wrote:
> 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 has exactly same combination for those 3 rows.
What query are you running?
В списке pgsql-admin по дате отправления: