Q: fixing collation version mismatches

From: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Q: fixing collation version mismatches
Date: 2022-11-13 20:45:32
Message-ID: Y3FXbJiKcp04HEER@hermes.hilbert.loc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear all,

just to confirm my understanding:

Is it correct to say that the following sequence will "fix"
all current collation version issues in a given database ?

REINDEX DATABASE db_in_question;
ALTER DATABASE db_in_question REFRESH COLLATION VERSION;
ALTER COLLATION every_collation_from_pg_collation REFRESH VERSION;

Note that I am currently _not_ concerned with minimizing
work by running this on objects only that really need a
reindex/refresh.

Thanks,
Karsten
--
GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christophe Pettus 2022-11-13 20:46:53 Re: Q: fixing collation version mismatches
Previous Message Adrian Klaver 2022-11-13 20:35:25 ON CONFLICT and WHERE