Re: Q: fixing collation version mismatches

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Q: fixing collation version mismatches
Date: 2022-11-13 20:46:53
Message-ID: B083C0A7-50DA-4CC1-A837-BB6B3FF2A3BE@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Nov 13, 2022, at 12:45, Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2022-11-13 20:54:54 Re: Setting up replication on Windows, v9.4
Previous Message Karsten Hilbert 2022-11-13 20:45:32 Q: fixing collation version mismatches