Re: pg_upgrade fails to preserve old versions of the predefined collations

2019-11-28 Thread Alexander Lakhin
28.11.2019 23:25, Thomas Munro пишет: > On Fri, Nov 29, 2019 at 9:08 AM Alexander Lakhin wrote: >> So for now it seems dangerous to use predefined collations as their old >> versions are not preserved by pg_upgrade and the user doesn't know which >> indexes affected by the actual ICU collation cha

Re: pg_upgrade fails to preserve old versions of the predefined collations

2019-11-28 Thread Thomas Munro
On Fri, Nov 29, 2019 at 9:08 AM Alexander Lakhin wrote: > So for now it seems dangerous to use predefined collations as their old > versions are not preserved by pg_upgrade and the user doesn't know which > indexes affected by the actual ICU collation changes. Yeah, we noticed this while working

pg_upgrade fails to preserve old versions of the predefined collations

2019-11-28 Thread Alexander Lakhin
Hello hackers, When dealing with an OS upgrade, a some kind of anomaly related to collations was found. Suppose, we have Debian 8 with postgresql 12 installed. Then we create a custom collation: CREATE COLLATION russian (provider=icu, locale='ru_RU'); and SELECT oid, collname, collnamespace, collp