Re: Explicit deterministic COLLATE fails with pattern matching operations on column with non-deterministic collation

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
Cc: James Lucas <jlucasdba(at)gmail(dot)com>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: Explicit deterministic COLLATE fails with pattern matching operations on column with non-deterministic collation
Date: 2020-06-05 01:22:01
Message-ID: 1442668.1591320121@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I wrote:
> 3. Hack things up so that the core code renames all these exposed
> functions to, say, ineq_histogram_selectivity_ext() and so on,
> allowing the additional arguments to exist, but the old names would
> still be there as ABI compatibility wrappers.

Here's a proposed v12 patch along those lines.

regards, tom lane

Attachment Content-Type Size
0001-use-query-collation-in-selectivity-estimation-v12.patch text/x-diff 28.3 KB

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Geoghegan 2020-06-05 02:03:32 Re: Potential G2-item cycles under serializable isolation
Previous Message Peter Geoghegan 2020-06-05 00:20:22 Re: Potential G2-item cycles under serializable isolation