Re: nondeterministic collations and statistics and pattern matching

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: morgothko(at)gmail(dot)com
Cc: pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: nondeterministic collations and statistics and pattern matching
Date: 2020-10-06 20:34:37
Message-ID: 1998880.1602016477@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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.

regards, tom lane

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Bruce Momjian 2020-10-06 23:38:48 Re: Request for further clarification on synchronous_commit
Previous Message PG Doc comments form 2020-10-06 18:59:25 nondeterministic collations and statistics and pattern matching