Re: pg_upgrading to 10.1 corrupts (varchar,varchar) UNIQUE indices

Palle Girgensohn <girgen@xxxxxxxxxxxx> · Fri, 22 Dec 2017 17:44:41 +0100



    Here's the prompt response I got from the maintainer of FreeBSD
      package, girgen@ 

    
      -------- Forwarded Message --------
      
        
            Subject:
            
            Re: pg_upgrading to 10.1 breaks some indices maybe due
              to changing providers for ICU
          
          
            Date: 
            Fri, 22 Dec 2017 17:44:41 +0100
          
          
            From: 
            Palle Girgensohn <girgen@xxxxxxxxxxxx>
          
          
            To: 
            rihad <rihad@xxxxxxx>
          
        
      Yes that is a knogen problem. I ahould document it better. The Built in support for icu is not the same as the patch. For upgrade to work and indeed for expected old behaviour of icu to work, the patch still needs to be applied for pg10. This work has not been done yet. 

Palle

> 22 dec. 2017 kl. 17:22 skrev rihad <rihad@xxxxxxx>:
> 
> Hi, please see my original post describing the problem: https://www.postgresql.org/message-id/e6f53eeb-ef46-3095-cd34-88550904fa02%40mail.ru
> 
> and a reply for a possible cause: https://www.postgresql.org/message-id/e6f53eeb-ef46-3095-cd34-88550904fa02%40mail.ru
> 
.