Re: hashing bpchar for nondeterministic collations is broken - Mailing list pgsql-bugs

From Tom Lane
Subject Re: hashing bpchar for nondeterministic collations is broken
Date
Msg-id 2137318.1670017756@sss.pgh.pa.us
Whole thread Raw
In response to Re: hashing bpchar for nondeterministic collations is broken  (Jeff Davis <pgsql@j-davis.com>)
Responses Re: hashing bpchar for nondeterministic collations is broken
List pgsql-bugs
Jeff Davis <pgsql@j-davis.com> writes:
> But assuming someone does use that combination of features in 15.1, and
> we release 15.2 with my fix in it, then the consequences could be
> severe: a pg_dump with default options on their bpchar-
> nondeterministic-collation-hash-partitioned table in 15.1 would be
> unrestorable in 15.2. They'd need to take a new pg_dump from 15.1 with
> "--load-via-partition-root" and then restore it in 15.2. Obviously that
> would be bad in any case, but it's more tolerable going between servers
> of different major versions.

Yeah.  Also, do we have this issue with hash indexes?  If so
reindexing might be necessary, which again would be more
palatable in a major release.

> So, given that this fix is unlikely to help many people in 15 and
> earlier, and that there's a chance that the fix is really painful for
> someone; I'm electing not to backpatch it.

+1

            regards, tom lane



pgsql-bugs by date:

Previous
From: Jeff Davis
Date:
Subject: Re: hashing bpchar for nondeterministic collations is broken
Next
From: Jeff Davis
Date:
Subject: Re: hashing bpchar for nondeterministic collations is broken