Q: fixing collation version mismatches - Mailing list pgsql-general

From Karsten Hilbert
Subject Q: fixing collation version mismatches
Date
Msg-id Y3FXbJiKcp04HEER@hermes.hilbert.loc
Whole thread Raw
Responses Re: Q: fixing collation version mismatches
List 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



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: ON CONFLICT and WHERE
Next
From: Christophe Pettus
Date:
Subject: Re: Q: fixing collation version mismatches