Postgres Pro
Downloads
Home   >   mailing lists

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

From Christophe Pettus
Subject Re: Q: fixing collation version mismatches
Date
Msg-id B083C0A7-50DA-4CC1-A837-BB6B3FF2A3BE@thebuild.com
Whole thread Raw
In response to Q: fixing collation version mismatches  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Responses Re: Q: fixing collation version mismatches  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List pgsql-general
Tree view 

> On Nov 13, 2022, at 12:45, Karsten Hilbert <Karsten.Hilbert@gmx.net> wrote:
>     REINDEX DATABASE db_in_question;
>     ALTER DATABASE db_in_question REFRESH COLLATION VERSION;
>     ALTER COLLATION every_collation_from_pg_collation REFRESH VERSION;

I may be totally off-base here, but shouldn't the REINDEX be the last step?

pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Q: fixing collation version mismatches
Next
From: Ron
Date:
Subject: Re: Setting up replication on Windows, v9.4