[PostGIS] #5687: PostgreSQL 17 regression failures with spgist indexes

[PostGIS]

#5687: PostgreSQL 17 regression failures with spgist indexes
----------------------+---------------------------
  Reporter:  robe     |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  blocker  |  Milestone:  PostGIS 3.5.0
 Component:  postgis  |    Version:  3.4.x
Resolution:           |   Keywords:
----------------------+---------------------------
Comment (by robe):

 Okay I think I pinpointed.  Seems ot have started going south after this
 patch

 https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=2af07e2f749a9208ca1ed84fa1d8fe0e75833288

 {{{
 Commit 2af07e2f749a9208ca1ed84fa1d8fe0e75833288 by jdavis

 Fix search_path to a safe value during maintenance operations.

 While executing maintenance operations (ANALYZE, CLUSTER, REFRESH
 MATERIALIZED VIEW, REINDEX, or VACUUM), set search_path to
 'pg_catalog, pg_temp' to prevent inconsistent behavior.

 Functions that are used for functional indexes, in index expressions,
 or in materialized views and depend on a different search path must be
 declared with CREATE FUNCTION ... SET search_path='...'.

 This change was previously committed as 05e1737351, then reverted in
 commit 2fcc7ee7af because it was too late in the cycle.

 Preparation for the MAINTAIN privilege, which was previously reverted
 due to search_path manipulation hazards.

 Discussion:
 https://postgr.es/m/d4ccaf3658cb3c281ec88c851a09733cd9482f22.camel@j-davis.com
 Discussion: https://postgr.es/m/E1q7j7Y-000z1H-Hr%40gemulon.postgresql.org
 Discussion:
 https://postgr.es/m/e44327179e5c9015c8dda67351c04da552066017.camel%40j-
 davis.com
 Reviewed-by: Greg Stark, Nathan Bossart, Noah Misch
 }}}

 Which sounds like something they will want to backport, so we might have
 to fix up other branches, before this gets applied to supported PostgreSQL
 versions
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5687#comment:1>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.