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 1tR8vj-007ZGH-Gy for pgsql-performance@arkaria.postgresql.org; Fri, 27 Dec 2024 11:54: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 1tR8vi-009Xeq-Fn for pgsql-performance@arkaria.postgresql.org; Fri, 27 Dec 2024 11:54:58 +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 1tR8vi-009Xei-4F for pgsql-performance@lists.postgresql.org; Fri, 27 Dec 2024 11:54:57 +0000 Received: from mout.kundenserver.de ([212.227.126.133]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tR8ve-001rjs-Lj for pgsql-performance@lists.postgresql.org; Fri, 27 Dec 2024 11:54:57 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=msym.fr; s=s1-ionos; t=1735300493; x=1735905293; i=msalais@msym.fr; bh=4pPrvjn0HlcUyNxLvak3fASfzRjKMNymRESJd4mnDPM=; h=X-UI-Sender-Class:From:To:Cc:References:In-Reply-To:Subject:Date: Message-ID:MIME-Version:Content-Type:cc:content-transfer-encoding: content-type:date:from:message-id:mime-version:reply-to:subject: to; b=XAvYZZst3R3ofxcvs+KsRTMMjezbqXf23dQE2tQFh7vwvBGcKUbc16k1f/3e26vR x6t4C9Q4Ey8arVaO364Lp16wUmht65T5zYl2uL7gUPOBwCQuNSSHJamGA4xrleOrw R+grf6dG8u6N32cvBX9zlnKytCEZMk3jTSa7hwdjYOWh1DAmkiG3AQgO8uTAJGr4m u/D3wZ8NZiIjZwpSghd0S++5f9j/qcTu18Kg0h22OQ+F4ckoqM2Pqs8aTcuRewGX6 jUMDwB0SW+4zX5s2DOmbzDXvJY88QMrg2CTmChf5T5gYRDQPgw0lBf5mYQeZa6huq hpG2V6fVNaHcEd+Q0g== X-UI-Sender-Class: 55c96926-9e95-11ee-ae09-1f7a4046a0f6 Received: from msim1 ([78.197.128.121]) by mrelayeu.kundenserver.de (mreue010 [212.227.15.168]) with ESMTPSA (Nemesis) id 1N4A1h-1taBKu0bx3-00wy3V; Fri, 27 Dec 2024 12:54:53 +0100 From: To: "'Sajjad Abid'" , "'Diomedes Dominguez'" Cc: References: In-Reply-To: Subject: RE: Reg. Postgres Unique contraint Date: Fri, 27 Dec 2024 12:54:52 +0100 Message-ID: <004d01db5856$23bde1c0$6b39a540$@msym.fr> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_004E_01DB585E.85833420" X-Mailer: Microsoft Outlook 16.0 Thread-Index: AQJ02Tax8kkdlHWLru6X4RgF+8GIzgIFBv2vAtbQTgSxoBn4IA== Content-Language: fr X-Provags-ID: V03:K1:Dq1nxOIVE9LP6BmcqVPFkNh2eqh9i0JbHuXzdN53re+olRzhJdd zwogTDr6QLoh53sGzMLZQVPHxg9TdW4ASWE5QA6JM4ZaH4YlUt6ZlMHd1JelgJ9s3aeZsW9 naLKMdbOKFftM2GovEZ2YsBJvQixk1wKrgYsEB+gJoxLj8HmF4H+IrPDoTHJKio87N2A9hV +SZWeZsp/NfK28She0oqg== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:VLPgrZ0QvSk=;vEBaCkeqh+UETp9izPRskf/5FPR sDTAPE6UQBIUojxob7gAJdrVMumWdb0biZ+upETxSRmpekYvGyyrwqGgM1N7LbAV6qm+iJaG8 6/8tPapJfLXvO20tvH+fBamF6QXOxy6Y+XTJTnaQdvJIk2lC4v15n9FVQeq9jdtujq8om0eBQ S8tcs8+EfQbKMJbiA7wlqx4hncpNIxiHSHniJG+EY8k0FxtxyAK7STvNTfXfhgxZlVlCWhrlU BzgFcy22fcahZG/lyMdx11R1ooPtn63kgmnhhRbrGcjI0PGuasr+uSUjn70hIZLWMTxRilSjv iqyBgHTXRvBUx8uUQZNHkmXKsnQPAh1Z/m+fQTSlM/eQkZZUqqjk8KmslVT1ANQER3tIar62f n4ouCH88hTecqn5MUTNFJRpE0/efCiP7PZVHOqV2FdyrDbl6QR4Z93nbmCZ+T3l2i1E3BEIAs +jujTEoh1SefrjMv450jPWLOWNPKOKt22ynhza0pnkHIWqE+41k1Y4p6ehrpEUpbzOuVFpQsl df2suLBDmCCrF1ApM7/v++lV6XjdQXep0PAQQLbTfrCb4un2DOEM2rINsb/08sWx8WPgr2zLq FzB0aw8FEXyyrnGdjCDJtQM+T0H/A96v2k0z7NQP4kq4v5r5LUFnABy4P7rFeOpt1cAd3Vfq4 WP9RfSYP0uY+Tc9S0VmAltnbj0BZ299MNF3uTulw4MGVnZlenb4hPJSLz4LR60zc6jfmkzuck cVQJCDpDV1yWw037AruVZyAcmF14++VXf0d8T/slv8VenuuM0IBOSM8LNd86MeOODzLlDHv5X E5TDSUQ1Isq3PV4bMScvl0eswp0AduUxlfwAodT5YK5Dk6eb5Hjo3WCGBlASqfBIhSz2G6k2L AGlm+bEBET5enIcT3f8lKq7cJHrdqpjf2KYPU9Y/MjcNr03Z6efhIrQbvnEfb8sUfZK1iCAm0 iMXMaBwuA8AHm/u2SsxjWmaIFab6KFQEBvSif1MvifAPiLOLnGDWcx1G9TFTro9IDp0XV3NJj Jj0/wC77dojjiCmRETfjdFmdwprmN5/y74Zplew List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multipart message in MIME format. ------=_NextPart_000_004E_01DB585E.85833420 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Hi, =20 Does the following query return something: =20 Select user_name, count(*) from your_table group by user_name having = count(*) > 1 =20 Best regards =20 Michel SALAIS =20 De : Sajjad Abid =20 Envoy=C3=A9 : mercredi 27 novembre 2024 05:28 =C3=80 : Diomedes Dominguez Cc : pgsql-performance@lists.postgresql.org Objet : Re: Reg. Postgres Unique contraint =20 Version of Postgres is 12.9 =20 On Wed, Nov 27, 2024 at 9:49=E2=80=AFAM Diomedes Dominguez = > = wrote: Which version of Postgres are you using?=20 =20 El mi=C3=A9, 27 de nov de 2024, 00:14, Sajjad Abid > escribi=C3=B3: A column is character varying(50), also on this column a unique = constraint is defined, but I found some duplicate values in this column = for some records user_name character varying(50)=20 CONSTRAINT user_name_unq UNIQUE ( user_name ) =20 Kindly help me to resolve this issue. =20 --=20 Thanks & Regards,=20 Sajjad Abid =20 --=20 Thanks & Regards,=20 Sajjad Abid ------=_NextPart_000_004E_01DB585E.85833420 Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: quoted-printable

Hi,

 

Does the following query return = something:

 

Select user_name, count(*) from your_table group by = user_name having count(*) > 1

 

Best regards

 

= Michel SALAIS

 

De : Sajjad Abid = <abidsajjad@gmail.com>
Envoy=C3=A9 : mercredi 27 = novembre 2024 05:28
=C3=80 : Diomedes Dominguez = <diomedes.dominguez@gmail.com>
Cc : = pgsql-performance@lists.postgresql.org
Objet : Re: Reg. = Postgres Unique contraint

 

Version = of Postgres is 12.9

 

On = Wed, Nov 27, 2024 at 9:49=E2=80=AFAM Diomedes = Dominguez <diomedes.dominguez@gmail.com= > wrote:

Which version of Postgres = are you using?

 

El = mi=C3=A9, 27 de nov de 2024, 00:14, Sajjad Abid <abidsajjad@gmail.com> = escribi=C3=B3:

A column is character varying(50), also on this column = a unique constraint is defined, but I found some duplicate values = in this column for some records

  user_name character = varying(50) 

  = CONSTRAINT  user_name_unq   UNIQUE ( user_name = )

 

Kindly help me to resolve this = issue.

 

--

Thanks & Regards, =

Sajjad = Abid


 

--

Thanks & Regards, =

Sajjad Abid

------=_NextPart_000_004E_01DB585E.85833420--