Re: Duplicate data even with primary keys enabled

From: Holger Jakobs <holger(at)jakobs(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Duplicate data even with primary keys enabled
Date: 2022-10-28 18:41:29
Message-ID: 74e777cb-c332-3db7-7c4a-784d408227d6@jakobs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron 2022-10-28 19:31:57 Re: Duplicate data even with primary keys enabled
Previous Message Teja Jakkidi 2022-10-28 18:27:14 Re: Duplicate data even with primary keys enabled