Content-Type: multipart/alternative;
 boundary="------------HtmkU03reiEs4h7g35C3qbd9"
Message-ID: <374b5d93-8681-b260-393f-73581c5344dc@gmail.com>
Date: Fri, 28 Oct 2022 14:31:57 -0500
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.2.2
Subject: Re: Duplicate data even with primary keys enabled
Content-Language: en-US
To: pgsql-admin@lists.postgresql.org
References: <8A481F39-97D5-4778-AC3C-A34CD29E00AB@gmail.com>
 <CAAo1mbnEV6QxHwnV6r2EUMXjb_Fz98+8eO6ZRU7eux4FTuF0YA@mail.gmail.com>
From: Ron <ronljohnsonjr@gmail.com>
In-Reply-To: 
 <CAAo1mbnEV6QxHwnV6r2EUMXjb_Fz98+8eO6ZRU7eux4FTuF0YA@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/374b5d93-8681-b260-393f-73581c5344dc%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------HtmkU03reiEs4h7g35C3qbd9
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

You're confusing PRIMARY KEY with UNIQUE.

On 10/28/22 12:59, Samed YILDIRIM wrote:
> Hello Teja,
>
> Could you please add some example lines? I need to see some examples to 
> say something more accurate.
>
> First of all, null != null in PostgreSQL. So, if any of those three 
> columns is null, it means it is unique and won't violate unique 
> constraints even if there is another row with the same values.
>
> Another thing, if you defined a composite primary key on those 3 columns, 
> it means that it will prevent inserting another row that has exactly the 
> same values on those columns. If you want to keep values unique on each 
> individual columns, you need to create 3 separate unique indexes/constraints.
>
> Best regards.
> Samed YILDIRIM
>
> On Fri, 28 Oct 2022, 19:52 Teja Jakkidi, <teja.jakkidi05@gmail.com> wrote:
>
>     Hello Admin team,
>
>     I have an issue where we are seeing duplicate data in one of the
>     tables. The table has primary key constraint defined on 3columns and
>     we are seeing duplicate data in these column data.
>     Is there any way to figure out why this could happen? Also is there a
>     way that the primary key constraint can be disabled during  inserts??
>     If so how can we find who disabled it? (Note that audit is not enabled
>     for the table)
>     Please suggest.
>
>     Thanks,
>     Teja.
>

-- 
Angular momentum makes the world go 'round.
--------------HtmkU03reiEs4h7g35C3qbd9
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    You're confusing PRIMARY KEY with UNIQUE.<br>
    <br>
    <div class="moz-cite-prefix">On 10/28/22 12:59, Samed YILDIRIM
      wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:CAAo1mbnEV6QxHwnV6r2EUMXjb_Fz98+8eO6ZRU7eux4FTuF0YA@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div dir="auto">Hello Teja,
        <div dir="auto"><br>
        </div>
        <div dir="auto">Could you please add some example lines? I need
          to see some examples to say something more accurate.</div>
        <div dir="auto"><br>
        </div>
        <div dir="auto">First of all, null != null in PostgreSQL. So, if
          any of those three columns is null, it means it is unique and
          won't violate unique constraints even if there is another row
          with the same values.</div>
        <div dir="auto"><br>
        </div>
        <div dir="auto">Another thing, if you defined a composite
          primary key on those 3 columns, it means that it will prevent
          inserting another row that has exactly the same values on
          those columns. If you want to keep values unique on each
          individual columns, you need to create 3 separate unique
          indexes/constraints.</div>
        <div dir="auto"><br>
          <div data-smartmail="gmail_signature" dir="auto">Best regards.<br>
            Samed YILDIRIM</div>
        </div>
      </div>
      <br>
      <div class="gmail_quote">
        <div dir="ltr" class="gmail_attr">On Fri, 28 Oct 2022, 19:52
          Teja Jakkidi, &lt;<a href="mailto:teja.jakkidi05@gmail.com"
            moz-do-not-send="true" class="moz-txt-link-freetext">teja.jakkidi05@gmail.com</a>&gt;
          wrote:<br>
        </div>
        <blockquote class="gmail_quote" style="margin:0 0 0
          .8ex;border-left:1px #ccc solid;padding-left:1ex">Hello Admin
          team,<br>
          <br>
          I have an issue where we are seeing duplicate data in one of
          the tables. The table has primary key constraint defined on
          3columns and we are seeing duplicate data in these column
          data.<br>
          Is there any way to figure out why this could happen? Also is
          there a way that the primary key constraint can be disabled
          during  inserts?? If so how can we find who disabled it? (Note
          that audit is not enabled for the table)<br>
          Please suggest.<br>
          <br>
          Thanks,<br>
          Teja.<br>
          <br>
        </blockquote>
      </div>
    </blockquote>
    <br>
    <div class="moz-signature">-- <br>
      Angular momentum makes the world go 'round.</div>
  </body>
</html>

--------------HtmkU03reiEs4h7g35C3qbd9--