Re: cache lookup failed for collation 0 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: cache lookup failed for collation 0
Date
Msg-id 21216.1555003241@sss.pgh.pa.us
Whole thread Raw
In response to Re: cache lookup failed for collation 0  (Jeevan Chalke <jeevan.chalke@enterprisedb.com>)
Responses Re: cache lookup failed for collation 0
List pgsql-hackers
Jeevan Chalke <jeevan.chalke@enterprisedb.com> writes:
> Do you mean, the code in get_collation_isdeterministic() should look like
> something like below?

> If colloid = InvalidOid then
>   return TRUE
> ELSE IF tuple is valid then
>   return collisdeterministic from the tuple
> ELSE
>  return FALSE

I think it's appropriate to fail if we don't find a tuple, for any
collation oid other than zero.  Again, if you trace through the
behavior of the longstanding collation check functions like
lc_ctype_is_c(), you'll see that that's what happens (except for
some hardwired OIDs that they have fast paths for).

            regards, tom lane



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Pluggable Storage - Andres's take
Next
From: Tom Lane
Date:
Subject: Re: setLastTid() and currtid()