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 1tqeGd-008JY5-8O for pgsql-general@arkaria.postgresql.org; Fri, 07 Mar 2025 20:25:59 +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 1tqeGb-00GxNw-Cp for pgsql-general@arkaria.postgresql.org; Fri, 07 Mar 2025 20:25:57 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tqeGa-00GxNP-8t for pgsql-general@lists.postgresql.org; Fri, 07 Mar 2025 20:25:57 +0000 Received: from fout-a3-smtp.messagingengine.com ([103.168.172.146]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tqeGY-001YYu-0W for pgsql-general@postgresql.org; Fri, 07 Mar 2025 20:25:55 +0000 Received: from phl-compute-10.internal (phl-compute-10.phl.internal [10.202.2.50]) by mailfout.phl.internal (Postfix) with ESMTP id 2FC38138271C; Fri, 7 Mar 2025 15:25:53 -0500 (EST) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-10.internal (MEProxy); Fri, 07 Mar 2025 15:25:53 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm3; t=1741379153; x=1741465553; bh=Yy0c3Ll5+hE78sUYCrf3WYtd7hnix3LflAvFuhc8OBk=; b= A4v8nMXMIbwoKRGLcnji+UyzwiRGYKNlsF4jxuuO5clpQd9kR4gNQzIkpsVaKC6W WXoL3Q8Cc1Ki/5QRevly/0GY64AKnihrOJLY7WbFyMD/wMMMFPD4UEm52mfxrpzM oUadVt2SLBox1xRnELXvy/JyDyn8XrBtBix83Mql2cyCtCUKnlzfgyt3ja0PzlaD 79c4dfdTSprK5qYZhi4jhZFf9wKwg7X1naYzYfBMyBMU6qXD77FPixTnt+YK7Jkn p4jolkp8JWPszAzGhx2/rLcTwLniXQ4LzK8WnK66hN84R1CUL+u6vYOgM9LRyncc TeFaSf1WrRJALYwv8wz4DQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t=1741379153; x= 1741465553; bh=Yy0c3Ll5+hE78sUYCrf3WYtd7hnix3LflAvFuhc8OBk=; b=5 UFjciEaN2T1gYWFJjBj0/KGD0POCJTFuEFsjthFAugwXA3APOzUS5h7Ocb8BhuOy 04bBbqYQuytq1enUhQ+doyweyfQz9/rtS0+bxQSrZi/638plvRw5WyX5Yx7RDhby QHZRS1IxmzJ1nMijHYxnnHAL2KT9IiubFyL4IrqqWwCxqPA4P3z2KDzq1jkaScX4 1upUIxGBVaXG5n9GdlVX+hV5FIgTHPRHKegl3WOTN0BgumTJtpZzWDIFw5T8jGFf pkSD/9gZCR7WlypgprvEMAIDgxIOVV+hh/tfesATGp8ZHucNZGiT7VELptrAJ0WM wObnhY+b2E7ZSD+E/ZGcA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefvddrtddtgdduudduieduucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggv pdfurfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucenucfjughrpefkff ggfgfuvfevfhfhjggtgfesthekredttddvjeenucfhrhhomheptegurhhirghnucfmlhgr vhgvrhcuoegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtohhmqeenucggtf frrghtthgvrhhnpeehvdeiffdvieetleejgeduieefhefhiedvffelueehveeutedugeff keehtdfgieenucffohhmrghinhepphhoshhtghhrvghsqhhlrdhorhhgpdgprghmrgiioh hnrdgtohhmpdgrmhgriihonhdrtghomhenucevlhhushhtvghrufhiiigvpedtnecurfgr rhgrmhepmhgrihhlfhhrohhmpegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrd gtohhmpdhnsggprhgtphhtthhopedvpdhmohguvgepshhmthhpohhuthdprhgtphhtthho pehmrghrkhgsrhgrugihjhhusehouhhtlhhoohhkrdgtohhmpdhrtghpthhtohepphhgsh hqlhdqghgvnhgvrhgrlhesphhoshhtghhrvghsqhhlrdhorhhg X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 7 Mar 2025 15:25:52 -0500 (EST) Message-ID: <513ddbee-135c-4af2-b6f6-acca667b8d09@aklaver.com> Date: Fri, 7 Mar 2025 12:25:51 -0800 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Duplicate Key Values To: mark bradley Cc: pgsql-general References: <36356aa1-1a5c-44af-a1c0-f190249812ca@aklaver.com> <6aee94f9-d421-4622-bccc-bdac37969be0@aklaver.com> <75b33741-ee99-4524-b63a-edad21c1266d@aklaver.com> <9d919848-3fe1-46fd-b343-c5f2931864f7@aklaver.com> Content-Language: en-US From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 3/7/25 11:47, mark bradley wrote: > Wouldn't that be nice 🙂 No, because you would end up with a mess. My AI rant: AI is neither artificial or intelligent. It is human code that pattern matches and then throws the matches against the wall and hope something sticks. It is left to the human to clean up. At any rate, in this post: https://www.postgresql.org/message-id/75b33741-ee99-4524-b63a-edad21c1266d%40aklaver.com You where provided an answer, which is further extended here: https://www.postgresql.org/message-id/CAKAnmm%2BBBBaXGN2xPHhXywkwb72UWzinWu2wQ5WadcMw3_57rQ%40mail.gmail.com > > > Best regards, > Mark Brady > _amazon.com/author/markjbrady _ > ------------------------------------------------------------------------ > *From:* Adrian Klaver > *Sent:* Friday, March 7, 2025 10:55 AM > *To:* mark bradley > *Cc:* pgsql-general > *Subject:* Re: Duplicate Key Values > On 3/7/25 06:34, mark bradley wrote: >> This is what MS Copilot has to say about this apparent bug where >> Postgres inserts extra rows violating a primary keys uniqueness constraint: > > > >> What to do?  I hesitate to just delete my tables and start over because >> this error will reoccur. > > Let the AI solve it. > >> >> Best regards, >> Mark Brady > > > -- > Adrian Klaver > adrian.klaver@aklaver.com > -- Adrian Klaver adrian.klaver@aklaver.com