Horton
Menu

Re: Reg. Postgres Unique contraint

Burcin Yazici <burcinyazici@gmail.com>

View thread
From: Burcin Yazici <burcinyazici@gmail.com>
To: Sajjad Abid <abidsajjad@gmail.com>
Cc: Diomedes Dominguez <diomedes.dominguez@gmail.com>, pgsql-performance@lists.postgresql.org
Date: 2024-11-27T06:22:36Z
Lists: pgsql-performance 
hi,

  



  make sure that the values are really duplicated first..


  



  - check  the collation of column. 


  - check accent chars exist.


  - check lowercase, uppercase


  - check white space, tabs etc.


  



  
    burcin
  
  
    

    
      On 27 Nov 2024, at 07:28, Sajjad Abid <abidsajjad@gmail.com> wrote:

      

    
  
  
    
      
      
        Version of Postgres is 12.9
      

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

        
        
          

            Which version of Postgres are you using?
          

          
            
              El mié, 27 de nov de 2024, 00:14, Sajjad Abid <abidsajjad@gmail.com> escribió:

            
            
              
                
                  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