Re: nondeterministic collations and statistics and pattern matching

On Tuesday, October 6, 2020, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> PG Doc comments form <noreply(at)postgresql(dot)org> writes:
> > If exists statistic with nondeteministic collation inherited from column
> > collation then using pattern matching with collation will give an error.
>
> Yeah, that's a known problem we fixed months ago.
>
> > There is no information about it. ((
>
> Other than the 12.4 release note entry, you mean?
>
> > I have seen this thread
> > https://www.postgresql.org/message-id/flat/CAAFmbbOvfi%3DwMM%
> 3D3qRsPunBSLb8BFREno2oOzSBS%3DmzfLPKABw%40mail.gmail.com
> > But I can't apply this patch for some reasons.
>
> What is your point exactly? You think the documentation should
> describe your unspecified reasons for not updating to 12.4?
> I'm afraid I'm not a telepath.
>

While it doesn’t replace the need for users to look at release notes we are
generally pretty good at concluding patch threads with “applied,
back-patched to vX” comments but didn’t do that here.

David J.