Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rsiK9-008mEE-Sl for pgsql-admin@arkaria.postgresql.org; Fri, 05 Apr 2024 12:05:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rsiK8-00ELtQ-H3 for pgsql-admin@arkaria.postgresql.org; Fri, 05 Apr 2024 12:05:36 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rsiK8-00ELrU-0B for pgsql-admin@lists.postgresql.org; Fri, 05 Apr 2024 12:05:36 +0000 Received: from mail-lj1-x233.google.com ([2a00:1450:4864:20::233]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rsiK3-000mVg-V9 for pgsql-admin@lists.postgresql.org; Fri, 05 Apr 2024 12:05:35 +0000 Received: by mail-lj1-x233.google.com with SMTP id 38308e7fff4ca-2d485886545so37174281fa.2 for ; Fri, 05 Apr 2024 05:05:31 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1712318731; x=1712923531; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:autocrypt :references:in-reply-to:date:to:from:subject:message-id:from:to:cc :subject:date:message-id:reply-to; bh=fMuG7+yJN0BYPLCWYPVaM1VQOxcAsDNKjx7h34iJdfU=; b=JvwajCV6Ki/V3Kzf8UkxMeMnj6ZKqI77wkN4gI539Rss2TDlTRAnvHCElEzl5eUoAd M5mrcjGtC+RJdyScqzhJkkJvoeWvjX0PFx5SpqlzXciKFCbGJzaEkoO5uZIldNfnRP8A YVNtffCsHi/MtdWRF5dMsc/uQkvcl95c7lr4ZVNJx2vgftkJf325RLWjEy+N1HACM+Zj Iuzsh4O8gA7lkQGFvL3vGIGom+dVf4Oj70YdqGMl83V2to5geLso6aV5WbqFBkc+G/yG 1aiGNz2WWc7ineyeRdiiS4T1LNIwvg0+lDHyaf4xCQ0TVUBuaLn9Fk7ityMGXJ42Ynxs hlJQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1712318731; x=1712923531; h=mime-version:user-agent:content-transfer-encoding:autocrypt :references:in-reply-to:date:to:from:subject:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=fMuG7+yJN0BYPLCWYPVaM1VQOxcAsDNKjx7h34iJdfU=; b=DAhVGmChs9Zh0fqdfwzGzXONhJniNJF6ktWegrjxb0o47VUAwvP3V6Xy4dWYIOwvgH 0C09UTSOyC1UcUriSmveQwdWlZrnkLWcJfSF2/UaKDhBUv39PcFcd/+RHhR8e4m8ut7Q I7wfG+rShnnv69OjfrZrtVIDMJE7Q0zgeO/srnrFkNBqf2G+M3DaEm6lbuzVT7R5skCQ EsRWh4voL2e9NRuh9LIchxoEiABzgb94TJC1jcfrobWGn/CDdEWlJNob2r7zi/lOxVPg /DKDE03h437vK6MEFiA+KNZedDzL5SVsHkCj32xgJ5FOnPkyfRwKx5YYXCLZIPmFjhnB WeLA== X-Forwarded-Encrypted: i=1; AJvYcCWZYIKcBamFRZF0kOqpsX7NT8vKaEpd+6M0adxUyF7Gkht5+M9VWD5hD/ZxVp+dnO7QaIODdhOu3g/nocM4LNOfT1SbztnchkoLxI8M11lAhg== X-Gm-Message-State: AOJu0YyBQ7FutKD12ZuVC1wC25efaIMNgyM8OMHqIzxpf8yHusZ7x+ov vmPvZ2l4RF2jiyLzLDJGWr5oyKAQ4dHGUFntLVt+ETsFzrbpSmqfG+XrGh5++Kk= X-Google-Smtp-Source: AGHT+IEfaeox/Z5bSoHMJ0W9sDu3IHqu62MPhJvnajTnjubFtikwisr2Wumwj5KnePHiSfbe5WV4hw== X-Received: by 2002:a05:651c:b13:b0:2d8:d91:d77a with SMTP id b19-20020a05651c0b1300b002d80d91d77amr1737371ljr.5.1712318730842; Fri, 05 Apr 2024 05:05:30 -0700 (PDT) Received: from localhost.localdomain ([2001:871:5e:1d3:510c:640f:e080:e84]) by smtp.gmail.com with ESMTPSA id ay14-20020a05600c1e0e00b004146a304863sm6347208wmb.34.2024.04.05.05.05.30 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 05 Apr 2024 05:05:30 -0700 (PDT) Message-ID: <693e8a79b7570463b7e4914a2e31cd844bd6914c.camel@cybertec.at> Subject: Re: server log error on conflict do nothing From: Laurenz Albe To: Claudio Nasuti , pgsql-admin@lists.postgresql.org Date: Fri, 05 Apr 2024 14:05:29 +0200 In-Reply-To: References: Autocrypt: addr=laurenz.albe@cybertec.at; prefer-encrypt=mutual; keydata=mQINBGGDwAQBEADgbWy5cKXQld3N2mF+DFyiNFbi2oBl2T+XgxpPF8wTRw2D/u4bBKXP0SYSE/lA86jIVNWWU0gf1KODIkVvgJm2w4vH2VBV1b7ddVViGl1Iu+9zaRnv9wulhnH42KefepXnoean6UT1EzLM0opF/Ik0j+40TxdRtobkBprkQUyHDXWlHc2ffPs3SipyFEP9AVLf7ejRC46CXWDnsqjOBSMEW8Z4HiK/8RrPZBsKLts8dJxKF4pygOdJb0CWk8k/X1jbcfdxo+zOLjOMvJcSJ2pFdJmQHU+JufB3rePziqQ2S9Ur6sccr9XnTC1GVBWN4Lf5VHq+vf+bFJjVwg+2hrySZnAVfcOrxoqFLErr7ug1zN2nM1kcpgA4VWn4gxlJtYNYYq+9WxX5dtvnNANlG3ZCrRKQzl8lxtzoF6Zo7LUhEqPaHDwn7Rvs+IdbOn41lF5UDTJGqmC4gS/bZydW2Fy3YWm4aSaN9fgFf8D+PVkrlKAZB7gBLz1TyHjbcRf85cYF+GKKrDld5SzMB/V60VX3oP/Eo8ikFpyWaqiz1f9X7MBot3/PjJkY+wDzp3nmb19QEcOBuQiSQ4xds2r0HewbuHTAR68u8jNNMGmpm2j4x+g09Jd/WQDjqlTBZ/jEltH41fYCCPWMfljXTOOXu2eLNGdfi7ETZogtwjM9oTtSPQARAQABtCdMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5hdD6JAk4EEwEIADgWIQR0CqhbZGGABqoaSbdi8bhXA2EdmAUCYYPABAIbAwULCQgHAgYVCgkICwIEFgIDAQIeAQIXgAAKCRBi8bhXA2EdmM/6EADK232JCwmBzhlj8h7U9CjG6kx0JHP3uJGv+XfsHtHAlmY/RCwF1BHMEsRlk bT5UrLvJ2jb99bA9QARzhFaxzyn0F/BUKzuIjRGNs/n6d5dNUFA0kOt8sX+TacmC GEyjEBCrVCm4ranBiUyePn9NhHNWnaex7pJyqvMLLdwW9BEMJx0Fqo+DN8ukbXmYRsmhEtd3ue+x/luYmOmJnaGtzInaY5aOJYbW9XqoRIZkZvOCgbi1FfvNmoqWa+3oVxTOgw9RafjJDyW0lTHzKGjbGI5ofMU98l+/hKJFYJqWUF6VpFJY5YIcN/1lf4ZICMwDl+MPIVo/tpq8L10seJL28nLlvw3K+cI+TVW8IW/qL/LyVoDofI3USeOORuYmhpWRhik8JXX6xf3v6GrRilJIPWNFIJbxm1ZblQiQnOw3IOW7T+8nAmPin1HKqM3VrOrJQ2VtShsefNBibNAsr1oFaqcDBkn3yGG8i6CTW+FyO4PZ+/EwNxMVgktxbYdy5AT1/lpXr5tB+phhLIyVfiBvrWs5EThxYMQ/L8Y85c3GMsAy1l/x4h3jqySIYy3SCU9+jc5UVuNnXljbvkEzJ+NLWJ6C1rACFWrMszgPdh5tCrlRY9PpmYll4JbCgb8BtxEIUmR+xr50/ZElEK5iml7Q00KUekCcDt+36PsyGFTXBzNOrkCDQRhg8AEARAAzOZ2tLHlI4rrhG411h6cdCFjBZxuljaFCxFyHn3m6wbGLqwBUWC5k8UrRqjHMz88KcTSaNO7XGAmCqPdWd2SeflPZRnNTbjsVpw7mLdffsBm4JX7kki2Pvk5h0NtYeidXT1PSpc2ri4DutYXuT9uD8RAm1wUDCE5HQNUihT/WH6opt+hskHW21uHao0+y822tG0QQcGMqdQR5Vxdxj89wiEPdqW+HpU/oOZIhrf2E7prduAppxixjHy/o1rcnoznnJvc8D3+YgI9O0LrBMij89dM55pRGbLovTR1oGR3U74sX774+0xmSzeIKwZfiMUz7Atlvfk5SHOsRUFPN2Ux9kaXiiBibQpHFxt7b lDrT4wxdLJ/XCdbPPAyl+lZtOLsaHEEZvYNyTXwZc35dVf3R4/oz20HoG6s7ct8e1 AQygj43XAERzty9SkWgxs8+grp1PrGx6FHVSYRqBM8dS/ZR6yRVwOwJXPyaSSqfIF21DkE4j1y4n+ItSewPGoRp8K/yWCikt6qlkVkO2ASNIiX04fAbtzwVOaNn8ZMRNqyvLc1fED4sr49onE4cAIcBLjcC3KL+w9DUGRQCdziROj5H2Yl/sXGPdMciUHo/Uz2rggc+2th3bQiMhrHWSsBpUkDQp0yWewemstPpPgBL3h2fHKaX8B9oH5Qu/H1IgrOuX8AEQEAAYkCNgQYAQgAIBYhBHQKqFtkYYAGqhpJt2LxuFcDYR2YBQJhg8AEAhsMAAoJEGLxuFcDYR2YuPwQAMkpGtR80pQ1gVsONhdkqj0H2eU66efP/gO3CoyaoIcvrpKYj7C2HipVSmkt1gpByL0X4AMQ/vKuknUz3wd28Ba+G1dCfbVs/Xiusq+SmpUj5rTwmYqdSjWMuCo1R6oS5hdJMdUUJYGMT0QkVlm1KnW8jkmCTl9GzjDxOAsN9O6/6lPzaGFtk9XF+34Bry/N4HKiJkqpC4+UTd0AprPfzJ2jdT64e1F0+W88X8y1bTTgNrHwK4mDiLnlE4SKRuEm54lNhJz//ar86Or5BErzNpM6TL7lk44QS06hwsMrEdKIy8J/SYJPjfzR8tIUnKscclVpOgjKaBqC+0iFiVaRqAgfOlIEiezX6kMh5Q2FIUfqs46qWhhXjRrdKOEoStYAaikdLu5ZXr7vfb0ZaDh+ZwTQtbSMFolyOkecwI81MCdbMfT/1TqIGTOdAj5as9fAakk0jb2pXgUYQ8X1DVTR8ahSDVEaw9VTmWiSvTxvguVJ1Mb7gG4Gmh6aviDTJhfXtH4rPUNXhDLqrTH8JkJjyKROOMakIF68Hjse5vUfUxreBEOtb5r1Coa2Fe7ncJayaSE7ryrDbFqpZ 36UMAx4ulWMyqJajLNGY0DdG8qIsR5nxRhrnK/mrCidZ8F9/D3bWAl4rjtHlsztN59 +AnW5l0HsQcY9ntFL/zEBOaonjdJf Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.50.4 (3.50.4-1.fc39) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, 2024-04-05 at 13:10 +0200, Claudio Nasuti wrote: > we have a couple of concurrent application that sometimes goes in conflic= t performing an insert=C2=A0 > in a table. > At client side they are managed with clause "on conflict do nothing" and = work perfeclty. > That said when the conflict happens it is reported in the postgresql serv= er log. > I would like to know (I was unable to find the info in the documentation = nor in the maillist archive)=C2=A0 > if it is possible to configure the server to avoid that these "managed" c= onflict are reported as error in the server log. That cannot be. It must be some other constraint violations you see in the log. Normally all errors will reach the client, unless you catch them with an exception handler in PL/pgSQL code. Yours, Laurenz Albe