Re: Problems with unique constraints

Holger Jakobs <holger@xxxxxxxxxx> · Thu, 26 Jan 2023 13:42:24 +0100



    Am 26.01.23 um 12:52 schrieb Massimo
      Ortensi:

    
      we had OS upgrades, but with the same locale.
      Is there any chance to avoid rebuilding of all
        indexes/constraints by checking the correctness of indexes ?

      
          Massimo Ortensi -
              Responsabile ICT   

          
            Via Cristoforo Colombo, 21 -
              40131, Bologna  

              Tel.  051 4195069 

              Cell.  3351092560 

            
              mortensi@xxxxxxxxxxxxxxx
             
               
    In case of a change in the locale properties - albeit the name of
      the locale remained the same - index corruption is possible.
    This has been reported on RedHat platforms. The reaction of the
      PostgreSQL project was to incorporate the locale libraries by ICU.
      They can be used on demand. If they change, the database server
      will automatically reindex if necessary.
    If something in the OS libraries changes, the database server
      won't be informed.
    When indexes are corrupt (and data are fine), the best solution
      is to reindex all indexes over varchar and text columns.

    
    Kind Regards,
    Holger

    
    -- 
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
  
Attachment:
OpenPGP_signature

Description: OpenPGP digital signature