Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_upgrading to 10.1 corrupts (varchar,varchar) UNIQUE indices - Mailing list pgsql-general

From rihad
Subject Re: pg_upgrading to 10.1 corrupts (varchar,varchar) UNIQUE indices
Date
Msg-id ce51c510-bcff-5e34-e4c3-82cdd90ffaae@mail.ru
Whole thread Raw
In response to pg_upgrading to 10.1 corrupts (varchar,varchar) UNIQUE indices  (rihad <rihad@mail.ru>)
List pgsql-general
Tree view

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@pingpong.net>
To: rihad <rihad@mail.ru>


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@mail.ru>:
> 
> 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
> 
.

pgsql-general by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: pg_upgrading to 10.1 corrupts (varchar,varchar) UNIQUE indices
Next
From: rihad
Date:
Subject: Re: pg_upgrading to 10.1 corrupts (varchar,varchar) UNIQUE indices