Re: Wrong Results from SP-GiST with Collations - Mailing list pgsql-bugs

From Emre Hasegeli
Subject Re: Wrong Results from SP-GiST with Collations
Date
Msg-id CAE2gYzx_kC06hQkvF6VsFgt_47+vPfevsWee5gqy95LJE59PvQ@mail.gmail.com
Whole thread Raw
In response to Re: Wrong Results from SP-GiST with Collations  (Peter Geoghegan <pg@bowt.ie>)
Responses Re: Wrong Results from SP-GiST with Collations  (Peter Geoghegan <pg@bowt.ie>)
List pgsql-bugs
> I can't imagine how this could ever work, since a non C-collation
> string cannot be atomized into tokens like that. Considering each
> token successively during a comparison does not always produce the
> same answer as a straight comparison against the original string
> would.

I think the only fix is to remove support for those operators from the
operator class.  The logic on match_special_index_operator() doesn't
seem to need any change.  Patch attached.  As far as I understand, we
cannot back-patch catalog changes.  In this case, we can leave it
broken and apply the documentation part.

Attachment

pgsql-bugs by date:

Previous
From: Emre Hasegeli
Date:
Subject: Re: Standby corruption after master is restarted
Next
From: Vitaly V. Voronov
Date:
Subject: Re: BUG #15144: *** glibc detected *** postgres: postgres smsconsole [local] SELECT: double free or corruption (!pre