Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1lHU58-0000ei-76
	for pgsql-general@arkaria.postgresql.org; Wed, 03 Mar 2021 16:10:38 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1lHU57-0001Ez-5v
	for pgsql-general@arkaria.postgresql.org; Wed, 03 Mar 2021 16:10:37 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <kobruleht2@hot.ee>)
	id 1lHU35-0004na-9C
	for pgsql-general@lists.postgresql.org; Wed, 03 Mar 2021 16:08:31 +0000
Received: from portal-smtp-out.hot.ee ([194.126.101.125])
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <kobruleht2@hot.ee>)
	id 1lHU32-0002XZ-Sb
	for pgsql-general@postgresql.org; Wed, 03 Mar 2021 16:08:30 +0000
Received: from localhost (localhost [127.0.0.1])
	by vm-hot-relay10.estpak.ee (Postfix) with ESMTP id 2877C1CD9;
	Wed,  3 Mar 2021 18:08:26 +0200 (EET)
X-Virus-Scanned: Debian amavisd-new at vm-hot-relay10.estpak.ee
Received: from portal-smtp-out.hot.ee ([127.0.0.1])
	by localhost (vm-hot-relay10.estpak.ee [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id x2JEuszIHNIo; Wed,  3 Mar 2021 18:08:23 +0200 (EET)
Received: from mail.hot.ee (hot-relayhost3.estpak.ee [213.180.2.81])
	by vm-hot-relay10.estpak.ee (Postfix) with ESMTP id EAA101BDB;
	Wed,  3 Mar 2021 18:08:23 +0200 (EET)
Subject: Re: Duplicate key error
To: Adrian Klaver <adrian.klaver@aklaver.com>, pgsql-general@postgresql.org
References: <a8656d4f-d692-ffae-077e-304f348e25bf@hot.ee>
 <5b68b4b3-b957-5009-cf3e-4bbc9dcbd0d9@aklaver.com>
From: Andrus <kobruleht2@hot.ee>
Message-ID: <97577cda-b3fa-4edb-1c8a-2b39afad65c6@hot.ee>
Date: Wed, 3 Mar 2021 18:08:17 +0200
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101
 Thunderbird/78.8.0
MIME-Version: 1.0
In-Reply-To: <5b68b4b3-b957-5009-cf3e-4bbc9dcbd0d9@aklaver.com>
Content-Type: multipart/alternative;
 boundary="------------48D4F44D82095C8711D496A1"
Content-Language: et
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: 
 <https://www.postgresql.org/message-id/97577cda-b3fa-4edb-1c8a-2b39afad65c6%40hot.ee>
Precedence: bulk

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

Hi!

> There is no other process inserting  to this table?
>
There may be other processes in this server trying to insert same 
primary key value (server name).

Last inserted row data should remain.

Andrus.



--------------48D4F44D82095C8711D496A1
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>
    Hi!
    <br>
    <br>
    <blockquote type="cite"
      cite="mid:5b68b4b3-b957-5009-cf3e-4bbc9dcbd0d9@aklaver.com">There
      is no other process inserting  to this table?
      <br>
      <br>
    </blockquote>
    <p>There may be other processes in this server trying to insert same
      primary key value (server name).</p>
    <p>Last inserted row data should remain.</p>
    <p>Andrus.</p>
    <br>
  </body>
</html>

--------------48D4F44D82095C8711D496A1--