Re: Duplicate data even with primary keys enabled

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(dot)jakkidi05(at)gmail(dot)com> 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.
>
> 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?
>>