Re: Duplicate data even with primary keys enabled - Mailing list pgsql-admin

From Holger Jakobs
Subject Re: Duplicate data even with primary keys enabled
Date
Msg-id 74e777cb-c332-3db7-7c4a-784d408227d6@jakobs.com
Whole thread Raw
In response to Re: Duplicate data even with primary keys enabled  (Teja Jakkidi <teja.jakkidi05@gmail.com>)
Responses Re: Duplicate data even with primary keys enabled  (Teju Jakkidi vlogs <teja.jakkidi05@gmail.com>)
List pgsql-admin
Am 28.10.22 um 20:27 schrieb Teja Jakkidi:
> Hi YILDIRIM,
>
> Thanks for your response.
>
> We have a composite primary key on 3columns. We are noticing multiple 
> rows with same values in the 3pk columns which should not happen as 
> primary constraint is defined on them.
> Also, none of the columns are null.
>
> Regards,
> Teja. J.
>
Unless you don't post your CREATE TABLE command plus some INSERT command 
which lead to the described behavior, we won't be able to track the problem.


-- 
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012


Attachment

pgsql-admin by date:

Previous
From: Teja Jakkidi
Date:
Subject: Re: Duplicate data even with primary keys enabled
Next
From: Ron
Date:
Subject: Re: Duplicate data even with primary keys enabled