On Wed, 10 Apr 2024 at 20:21, Kirill Reshke <reshkekir...@gmail.com> wrote: > Do we need to force Collaction here like in other branches? > if (PQserverVersion(conn) >= 120000) > appendPQExpBufferStr(buf, " COLLATE pg_catalog.default");
According to the commit and codecomment that introduced the COLLATE, it was specifically added for correct regex matching (e.g. \w). So I don't think it's necessary, and I'm pretty sure adding it will cause the index scan not to be used anymore.
