From: | Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net> |
---|---|
To: | Julien Rouhaud <rjuju123(at)gmail(dot)com> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Aw: Re: Q: documentation improvement re collation version mismatch |
Date: | 2022-11-10 17:36:04 |
Message-ID: | trinity-05f5ba7c-998b-4ada-8dc2-0e7799fc862d-1668101764902@3c-app-gmx-bs14 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> > The comment above the query in the official documentation is rather assertive
> > (even if may true to the letter) and may warrant some more cautionary
> > wording ? Added, perhaps, some variation of this:
> >
> > > For now, the only safe way to go is either reindex everything, or everything
> > > except some safe cases (non-partial indexes on plain-non-collatable datatypes
> > > only).
>
> I think the comment is very poorly worded, as it leads readers to believe that
> objects with a pg_depend dependency on a collation are the only one that would
> get corrupted in case of glibc/ICU upgrade.
>
> I agree that there should be a big fat red warning saying something like
> "reindex everything if there's any discrepancy between the recorded collation
> version and the currently reported one unless you REALLY know what you're
> doing."
Given that it does not seem straightforward to mechanically detect objects
in need of a collation-associated rebuild I would think that such a warning
would change matters for the better, documentation-wise.
Karsten
From | Date | Subject | |
---|---|---|---|
Next Message | Philip Semanchuk | 2022-11-10 19:52:24 | IMMUTABLE function to cast enum to/from text? |
Previous Message | Adrian Klaver | 2022-11-10 16:31:07 | Re: pgadmin4 versions on Ubuntu 22.04 |