Re: Duplicate data even with primary keys enabled

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


Is it possible that a column is padded with spaces?   I’d check the length of each column.    Extra spaces to the right would make the columns unique.   You can’t tell if the column is padded with blanks from your query.   Checking the length would confirm each column is exactly the same.

Sent from my iPad

On Oct 28, 2022, at 3:42 PM, Teju Jakkidi vlogs <teja.jakkidi05@xxxxxxxxx> wrote:

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