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 1ts1uZ-00DS4L-Es for pgsql-general@arkaria.postgresql.org; Tue, 11 Mar 2025 15:52:55 +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 1ts1uX-001MKe-Sy for pgsql-general@arkaria.postgresql.org; Tue, 11 Mar 2025 15:52:53 +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 1ts1uX-001MK0-IP for pgsql-general@lists.postgresql.org; Tue, 11 Mar 2025 15:52:53 +0000 Received: from mail-il1-x12a.google.com ([2607:f8b0:4864:20::12a]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1ts1uU-002Fgl-2D for pgsql-general@postgresql.org; Tue, 11 Mar 2025 15:52:52 +0000 Received: by mail-il1-x12a.google.com with SMTP id e9e14a558f8ab-3d2a869d016so13815955ab.0 for ; Tue, 11 Mar 2025 08:52:50 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1741708370; x=1742313170; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=4YOYUomvlTUFCTTKbl+3C+qNfbkZYhOHwmozXRS3Mw4=; b=lBz1yvioPUSzFKAhD0HdveHcrt0PCcedUxZehLlDozZYmMkBNE3nDc1lk4/N5FD6BE a5YktGylHky6W0n6rDyikoavh5Tr8zEvZhOuRekF/GudP+60ncPBrrAOENQzr8f+GrmN VoD/zpRuVPbEvR/d79bDn/Ww3MWNpgKjZd9Wy7pQII2OHpHrNM9AIMNmdBvD1X4ekA/G WXYR5sKiccwAVclvvQYJnNhsXclfYPRpsKFICZWfWsW1hC15X/ShSlBLIt1yMeUmMJqr 9EmO/WsY8R9MCjyLKCCcMgbZkFoQM7g+weBof+nOhcjK+H29+D5SG2laOrkkInh3b2ze sjAw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1741708370; x=1742313170; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=4YOYUomvlTUFCTTKbl+3C+qNfbkZYhOHwmozXRS3Mw4=; b=aumYwfRP1/vVFlArg8S14tuggZt7t8VfcKtfx096eB8Z49xyRSBTPlHLWM0pO7oo6k +NABrKzwGwMHCAxbFBFLLcFeR6NC6NTO7Eex57qpfwEYCDfrtCA5tScAq5FYsZcrkVmc njLdkkcUG+U5GlNJBhpJvH4QSHU0rkdS2sE8wpwJNvonZXnf5IcngTfVKMGy8HEyMN7f 9R9AuIcMdyv/wHFpYTCPGaR7B2C8Q8QWa1Hc0JMZluMx7qrwqdIIIYFPtbzv6dR+h13H 1QfNIIKCfdHf5S9xK0yPSm50EowOLPRaoSdoUkL/t5yKF3Z0Dipg5TB8f1BhqzkkNmb+ nt6Q== X-Forwarded-Encrypted: i=1; AJvYcCUDSanUFOibM92v/pmqJXyWt+azVfl2xBb4VJyAvsfXnY+VaIIeDzPGrw46gqGadYYN87ioBd9Ap0chRY0D@postgresql.org X-Gm-Message-State: AOJu0YzgyGefj+/KJagYyC2ZA8kl1mgLiqXOc4Wc8qLHf8FzEcGs6X48 CkXwzVcOkN0Oh9iR0b9H/3SkVjRePQwpJ8JPoGwe8axeoCUcca0/YIII92Fkad1A1cSm17mDiqI tjoDG6Ni5Qhkds+OZHVcTUnwPHyak8kGo X-Gm-Gg: ASbGnctjdZi022Gm8UnFgtFQP+I6mbFFciWZqzV4Z+5mBT4CkO8hhGs1zLsuS78pRt9 EnFEee23VIwFAQMfuAcYElX2X0W26JpLqK+C+66DDi44qVk3awc2s4cuGbHpTnqtNcgFDuXyGgF DMwj9E/QJnM0zNjKG5b/ahGczLVri3MIKwGuVNrcXrflDuXPSrgp+XftHMDbal X-Google-Smtp-Source: AGHT+IFJPMTdTnQq/jqKwGQg6ZiTxqL74dRfx9t5x4Y41csufjqHIkHDKL9VjnAvfjoJcwpqH2jcbpm9PNXcw76j8Zk= X-Received: by 2002:a92:ca07:0:b0:3d1:9236:ca52 with SMTP id e9e14a558f8ab-3d44186fe89mr189829525ab.0.1741708369859; Tue, 11 Mar 2025 08:52:49 -0700 (PDT) MIME-Version: 1.0 References: <6aee94f9-d421-4622-bccc-bdac37969be0@aklaver.com> <75b33741-ee99-4524-b63a-edad21c1266d@aklaver.com> <9d919848-3fe1-46fd-b343-c5f2931864f7@aklaver.com> <513ddbee-135c-4af2-b6f6-acca667b8d09@aklaver.com> In-Reply-To: From: Greg Sabino Mullane Date: Tue, 11 Mar 2025 11:52:14 -0400 X-Gm-Features: AQ5f1JrIYhBi35QhcWJQ9DTrjHlS1QaMfroelC9S6R2-7m_yP2IeeRBagFYbg1g Message-ID: Subject: Re: Duplicate Key Values To: mark bradley Cc: Adrian Klaver , pgsql-general Content-Type: multipart/alternative; boundary="000000000000b01fd40630131400" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000b01fd40630131400 Content-Type: text/plain; charset="UTF-8" A reindex is not going to remove rows from the table, so we need to see how you came to the conclusion that it did. Cheers, Greg -- Crunchy Data - https://www.crunchydata.com Enterprise Postgres Software Products & Tech Support --000000000000b01fd40630131400 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
A reindex is not going to remove rows fro= m the table, so we need to see how you came to the conclusion that it did.<= /div>


Cheers,
Greg

--
= Enterprise Postgres Software Products & Tech Support

--000000000000b01fd40630131400--