Horton

Re: cache lookup failed for collation 0

Peter Eisentraut <peter.eisentraut@2ndquadrant.com>

View thread View on postgr.es
From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
To: Jeevan Chalke <jeevan.chalke@enterprisedb.com>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2019-04-15T07:37:27Z
Lists: pgsql-hackers 
On 2019-04-15 07:44, Jeevan Chalke wrote:
>     The root cause is that the same code match_pattern_prefix() is being
>     used for text and bytea, but bytea does not use collations, so having
>     the collation 0 is expected, and we shouldn't call
>     get_collation_isdeterministic() in that case.
> 
>     Proposed patch attached.
> 
> Looks fine to me.

Committed, thanks.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Commits

  1. Unbreak index optimization for LIKE on bytea

  2. Collations with nondeterministic comparison