nondeterministic collations and statistics and pattern matching
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/collation.html
Description:
If exists statistic with nondeteministic collation inherited from column
collation then using pattern matching with collation will give an error.
There is no information about it. ((
I have seen this thread
/messages/by-id/CAAFmbbOvfi=wMM=3qRsPunBSLb8BFREno2oOzSBS=mzfLPKABw@mail.gmail.com
But I can't apply this patch for some reasons.
If I knew about the problem I would not use nondeterministic collations and
choose another way.
PG Doc comments form <noreply@postgresql.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
/messages/by-id/CAAFmbbOvfi=wMM=3qRsPunBSLb8BFREno2oOzSBS=mzfLPKABw@mail.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
On Tuesday, October 6, 2020, Tom Lane <tgl@sss.pgh.pa.us> wrote:
PG Doc comments form <noreply@postgresql.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
/messages/by-id/CAAFmbbOvfi=wMM%253D3qRsPunBSLb8BFREno2oOzSBS%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.
Yes, I checked release version and updated to 12.4.
It should have been done right away. That was my fault.
But if where was information about release in the thread of patch then
there would be no question.
пн, 12 окт. 2020 г., 3:16 David G. Johnston <david.g.johnston@gmail.com>:
Show quoted text
On Tuesday, October 6, 2020, Tom Lane <tgl@sss.pgh.pa.us> wrote:
PG Doc comments form <noreply@postgresql.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
/messages/by-id/CAAFmbbOvfi=wMM=3qRsPunBSLb8BFREno2oOzSBS=mzfLPKABw@mail.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.