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 1lHUAb-0000q4-6A
	for pgsql-general@arkaria.postgresql.org; Wed, 03 Mar 2021 16:16:17 +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 1lHUAZ-0006eM-3p
	for pgsql-general@arkaria.postgresql.org; Wed, 03 Mar 2021 16:16:15 +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 <adrian.klaver@aklaver.com>)
	id 1lHUAY-0006e8-SL
	for pgsql-general@lists.postgresql.org; Wed, 03 Mar 2021 16:16:14 +0000
Received: from wout2-smtp.messagingengine.com ([64.147.123.25])
	by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <adrian.klaver@aklaver.com>)
	id 1lHUAU-0002bF-AH
	for pgsql-general@postgresql.org; Wed, 03 Mar 2021 16:16:13 +0000
Received: from compute4.internal (compute4.nyi.internal [10.202.2.44])
	by mailout.west.internal (Postfix) with ESMTP id 9119D17DC;
	Wed,  3 Mar 2021 11:16:08 -0500 (EST)
Received: from mailfrontend1 ([10.202.2.162])
  by compute4.internal (MEProxy); Wed, 03 Mar 2021 11:16:08 -0500
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h=
	subject:to:references:from:message-id:date:mime-version
	:in-reply-to:content-type:content-transfer-encoding; s=fm2; bh=r
	3TjWUPBfTAgDQUSKJVm1Hw1VuTUfvE2NkNEIJ/Tzjs=; b=cwv7Cj8gF6gPB2QoO
	grLfQ6vmeXdUDlxri6NMKxbGqWwF3uEn3ea+XHrp0vP8knMLtVvwrW9GdNiPTzhI
	6m5Jnw+5nC1zvHYMRtOH/Gj6uAOeVcJ3/PS1dBIAsgXYtBMTNHyHUpbM8Sfp2Z+9
	1de6pWrrecO4S4oB8dZ1ymbpjpILaKflgdL2QmdOjNfowRrhe2QQOb/WOfP9LjTe
	zjnaNNwmWouIQGQH/iPxy0EUZ17tiL6CgXKuhugFDuCY36Sfsjs0FXUJedA4iNV9
	fbAItNeWHfOj5yYD7Y3S9T5d4Lz4GQcDwPRU9gvabQKZFujQGBDF7ARQ+HaHr3Z0
	WDfCQ==
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=
	messagingengine.com; h=content-transfer-encoding:content-type
	:date:from:in-reply-to:message-id:mime-version:references
	:subject:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender
	:x-sasl-enc; s=fm2; bh=r3TjWUPBfTAgDQUSKJVm1Hw1VuTUfvE2NkNEIJ/Tz
	js=; b=TmpvRXbWSwHs9v3060lWA2MwvjRdgN2oQjxPCzHzrlJJJFz/e9Zxkoe2a
	0+Z3bSH1f2tJU55sCNsjy8m/h7f83OrKjm6XKvy52gg3bjLXXIZ1bJx0w0w9xoZy
	Uh3LcsK+fxeNQh7UdovZdaMpdUS52jXeeadyVO1YTCEaTuVsPSoUON9t1Zryi7Rj
	Tk9Yr+5f21tbPD+GCg0zu7pV8YdfkUachS0dR2UqRHYVJx5s/6oO+CmQM6s2Y4I2
	kirMUDAAd4rwYogKlI3VAiG/txGMfk5L4nJvZcNXBjPf1iQ9a7buTFjxOTcR/GrZ
	4sniq/Ao+ZitDpNXd1qxKzSDP7/ew==
X-ME-Sender: <xms:R7Y_YF3RBqHjv_IhtT58hp1DTJmM5tvBPGySqeLPoxVDX-DTMweYHg>
    <xme:R7Y_YP6GcZ-As_Qn-NxaehbOP4V5NaMnd7sSJnRWbIGpJ5ahlqlhVEjeTefkIEsVB
    3Y_rKYDyNIp1BY>
X-ME-Proxy-Cause: 
 gggruggvucftvghtrhhoucdtuddrgeduledruddtvddgkeegucetufdoteggodetrfdotf
    fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen
    uceurghilhhouhhtmecufedttdenucenucfjughrpefuvfhfhffkffgfgggjtgfgsehtke
    ertddtfeejnecuhfhrohhmpeetughrihgrnhcumfhlrghvvghruceorggurhhirghnrdhk
    lhgrvhgvrhesrghklhgrvhgvrhdrtghomheqnecuggftrfgrthhtvghrnhepveevfeevfe
    eugeffkeekhfegieeufffgteeujedvgffhueejjefhkeejleegtdegnecukfhppeeljedr
    uddufedrvddujedrvdejnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrg
    hilhhfrhhomheprggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtghomh
X-ME-Proxy: <xmx:R7Y_YO8NFOtgdJdnvYyobuu8ZXFU6x42Z9Jrw2_KvwkE1i7dtPTX6w>
    <xmx:R7Y_YGUEPaqp70gd6LCFsdonX8THyqWPk7nZeePVbVZIEOT90_MxAA>
    <xmx:R7Y_YBqYcn-1p76KY1Ijqe_fHvTpddSPIyqhR1Sw48GiH6EwVIcStg>
    <xmx:SLY_YNBN2Ouub8B4vTzPza4sWBb2Akv_f1802hZusSRfEtPUlsmSgQ>
Received: from [192.168.1.4] (97-113-217-27.tukw.qwest.net [97.113.217.27])
	by mail.messagingengine.com (Postfix) with ESMTPA id 4777224005B;
	Wed,  3 Mar 2021 11:16:07 -0500 (EST)
Subject: Re: Duplicate key error
To: Andrus <kobruleht2@hot.ee>, pgsql-general@postgresql.org
References: <a8656d4f-d692-ffae-077e-304f348e25bf@hot.ee>
 <5b68b4b3-b957-5009-cf3e-4bbc9dcbd0d9@aklaver.com>
 <97577cda-b3fa-4edb-1c8a-2b39afad65c6@hot.ee>
From: Adrian Klaver <adrian.klaver@aklaver.com>
Message-ID: <c22a9fa0-9f3a-8b68-c1d4-a430cf7286bc@aklaver.com>
Date: Wed, 3 Mar 2021 08:16:06 -0800
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101
 Thunderbird/78.8.0
MIME-Version: 1.0
In-Reply-To: <97577cda-b3fa-4edb-1c8a-2b39afad65c6@hot.ee>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 8bit
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/c22a9fa0-9f3a-8b68-c1d4-a430cf7286bc%40aklaver.com>
Precedence: bulk

On 3/3/21 8:08 AM, Andrus wrote:
> 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).

And if that name already exists there would be a duplicate key error.

> 
> Last inserted row data should remain.

I'm not understanding the above.

> 
> Andrus.
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com