Re: Duplicate data even with primary keys enabled

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]


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.

Teja. J.

On Fri, Oct 28, 2022 at 1:27 PM Scott Ribe <scott_ribe@xxxxxxxxxxxxxxxx> wrote:
> On Oct 28, 2022, at 2:15 PM, Teju Jakkidi vlogs <teja.jakkidi05@xxxxxxxxx> 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?

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux