[PostGIS] #5790: Postgis-functions in Materialized views fail in Postgres 17 due to not fully qualified search path

[PostGIS]

#5790: Postgis-functions in Materialized views fail in Postgres 17 due to not
fully qualified search path
----------------------+---------------------------
  Reporter:  maxbo    |      Owner:  robe
      Type:  defect   |     Status:  closed
  Priority:  high     |  Milestone:  PostGIS 3.4.4
 Component:  postgis  |    Version:  3.4.x
Resolution:  fixed    |   Keywords:
----------------------+---------------------------
Comment (by landry):

 i dunno if i should file a new issue, because we face the exact same
 symptoms using 3.5.2/psql 17.6 on debian 13 (so, supposedly with this
 issue fixed), cf https://gitlab.com/panoramax/server/api/-/issues/304

 from a psql shell, refreshing the MV fails at the first try, but works at
 the second:

 {{{
 panoramax=> refresh materialized view pictures_grid ;
 ERROR:  column "public"."pictures"."geom" must be a geometry or geography
 panoramax=> refresh materialized view pictures_grid ;
 REFRESH MATERIALIZED VIEW
 }}}

 from psycopg2 code, the sql query to refresh the MV fails all the time.

 the materialized view is defined in
 https://gitlab.com/panoramax/server/api/-/blob/develop/geovisio/migrations/20251202_01_Q3g59
 -pictures-grid-logged-only.sql#L16, and uses
 {{{
 ST_EstimatedExtent('public', 'pictures', 'geom')
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5790#comment:9>
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.