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 1tR9un-007g0X-0r for pgsql-performance@arkaria.postgresql.org; Fri, 27 Dec 2024 12:58:05 +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 1tR9um-00A06w-4r for pgsql-performance@arkaria.postgresql.org; Fri, 27 Dec 2024 12:58:03 +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 1tR9ul-00A06j-OJ for pgsql-performance@lists.postgresql.org; Fri, 27 Dec 2024 12:58:03 +0000 Received: from mout.gmx.net ([212.227.15.15]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tR9ui-001sBt-B8 for pgsql-performance@lists.postgresql.org; Fri, 27 Dec 2024 12:58:02 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1735304280; x=1735909080; i=shammat@gmx.net; bh=pVL91cDjvGW0xx8Y6YjLEQPo0/HV2dZCU8lGk2ffRzw=; h=X-UI-Sender-Class:Message-ID:Date:MIME-Version:Subject:To: References:From:In-Reply-To:Content-Type: Content-Transfer-Encoding:cc:content-transfer-encoding: content-type:date:from:message-id:mime-version:reply-to:subject: to; b=aF3Px8JAoeRXDkgEeM9OWqgX0NEBwoKTfpLv+K/uzCeyva5iQHV2O9sziuGhYEfX Nt0DNxr7Uxzuc3SbZNRWXNFFJFWcZ3fabb6/jXUCIH8cvmk/g4VggidVfONPbpPFQ L2Hjco7bcQKS8BdwmxN8WbrAl1tYpyFWDO59sB233oddyb968u7AJOEZh2wxdxyhQ iJS6LBbk+O9mdKd3ebWxTFQ8Zeg7QYDiClcLB8uEVG0ulCrDn2Fpv3FqE8z5V44/Q FE0tHQETZhcF6J5r47c7IxzNVt0BYe8wpT0Y6Dpkz24EyANPVgaKipoSEpNgVWKMh lAu4c1Kqf1/effhAog== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from [192.168.178.31] ([88.217.180.197]) by mail.gmx.net (mrgmx004 [212.227.17.190]) with ESMTPSA (Nemesis) id 1Md6Qr-1tzwpg3mr5-00ZNwZ for ; Fri, 27 Dec 2024 13:57:59 +0100 Message-ID: Date: Fri, 27 Dec 2024 13:57:59 +0100 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Reg. Postgres Unique contraint To: pgsql-performance@lists.postgresql.org References: Content-Language: de-DE, en-US From: shammat@gmx.net In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: V03:K1:0MfwPUIB3VCLr75aEPVS//IHf8onFums/3MQ5Lb2YAn8cTvkF7/ /mk4s50c+agzhK+hab4O2Mb48sgklHmRGSAAvKEQz0+fjs7d7yk3zu2C3vNxR7MnTBM9q/4 9zpG8rU3+P15cAGE7pVjgp3Qaj/301JWbU5WUBxTW/+eOY0+dWgG0mM+5vYbhHdR1OyPqL9 MRCyotJyCjnVhL7Wk7tCw== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:z53SrsA0eNs=;jWeDp8IIDS2yj2WxNEy/eqLCI+i TT10MXUoVILr+KHuVNo1cndkAGXGwfCp8koAFiXVmBp/C+4be7il/3jFwqt58vQ6NJtjRBqAu c8rO7vsUB9U1uDXyujZEYNpMaUEiuAJiFUcq/43XqkvCk8Ny/I0KiUH4CHriWHMqeHRMmfURC 2u/W0X+WMgm0JsP5/AYti+fDX+xx4bTWK4RrE6lYzZTFE679IiWKLvokm3Z7lfu0jVDQi5TEA oGEFSO1O6GTl3xwkqlTKA8BmbvIleODzsjY/+P82MTfYEKGdnADZbRJQCUQHaRUvTeF8u6bVy RWnI382XUCYZRbiSUJ+Zq9jJxYNaQ7j3M/3V5mvdtIKVziwzdM3myzfXj4sMfz61Ae+azKnFT PRCWDuF1SSh+U1jOzhMpmnwZkt+jX1PLVKhptl54ocKvBgeA2Q9PajOQbQ4FvNqAo4TZCRa+R 8X8O2Shosi3QYu9rpuC8fth60BeqfwFbJdjJyAa5+hdsbW7SGWGWIb9BHhCXW9CEAGta/OWo+ v1M+HpEd9i2TEZMdIqPql/LSXxP1qu40iugk/uSCou+Hbyyx/F5dguGJC96nZUta0gTrszgOr xXtsRQeFJTPty4tLL0rMlT5/oBADM1cmgfLGGt/jQTVjCrdWZzHIAVR14fEO42o/j0oeFnTwN CysIieB+qeUl1nkO2e0vVChmdDrKLGY9F8FBwcU6S7QL1J5tZlYfFpZ7R4X+aZyOaRqSRPRZl rgaEZG0ZaqGK7YBy6LX6fZHA29QO/UOWxLc3qnU8HGKkDEa1iBKkcC+EkYMA7m30HLBBGUizH wvSsjSti/GUFKpHZefYL+1RWi3TmOR7JGGMLQWfUFeczYHb+gj7c29i6kBuJ/ogQiah8+H9od 7DNhryNAiO7O5wYtmCc3DsEheBWpl12CdeOHq1MlSODucwQrNsSFkF5Ea8kzqJQOIs2l4ETNN 7tRrv3a1t6tJqvk/Sp29w2czj/kSfC9I2gL0ZfmOcqLYk/4nM2hmPmDuVpUnkPjyVVTUNGIne Ib2yiTG01LtikRjO/eHXwmoqeFoWeWiEGw+jN8W01MdvF4wfOGOtKL2LOu+LxRRMhGpMg3qQA CQdEEHWuWcAhzaG1b1OEJSpiZnI8bf List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Am 27.11.24 um 05:14 schrieb Sajjad Abid: > 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 ) Most likely a locale/encoding problem. See: https://wiki.postgresql.org/wiki/Locale_data_changes