[raster] Calling ST_Intersects in matviews causes unrestorable pg_dump

[nblumoe]

I am using materialized views which include calls to ST_Intersects. After dumping them via pg_dump, I am not able to restore them with pg_restore because refreshing the mat views fails:

pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 7965; 0 74457 MATERIALIZED VIEW DATA company_level_production_risk_all_sectors postgres
pg_restore: [archiver (db)] could not execute query: ERROR:  type "geometry" does not exist
LINE 1:  SELECT $1::geometry OPERATOR(public.&&) $2 AND public._st_i...
                    ^
QUERY:   SELECT $1::geometry OPERATOR(public.&&) $2 AND public._st_intersects($2, $1, $3) 
CONTEXT:  SQL function "st_intersects" during inlining
    Command was: REFRESH MATERIALIZED VIEW public.company_level_production_risk_all_sectors;

This looks similar to ​https://trac.osgeo.org/postgis/ticket/3012 and might be caused by a search_path problem as geometry is referred to without the schema name.

The invocation is on ST_Intersects(raster, geometry)

[robe]

I'm seeing this case in raster code and not in PostGIS code, so switching back to raster

[robe]

Should be fixed at r17313 for PostGIS 2.5.2

I'll backport to 2.4 and upport to PostGIS 3.0.0 once tests are done

[robe]

In 17314:

Schema qualify all geometry casts in raster code, otherwise materialized views do not resture
References #4291 for PostGIS 3.0.0

[robe]

In 17315:

Schema qualify all geometry casts in raster code, otherwise materialized views do not resture
Closes #4291 for PostGIS 2.4.7

[robe]

In 17316:

Schema qualify all geometry casts in raster code, otherwise materialized views do not resture
Closes #4291 for PostGIS 2.5.2
Missed some spots in last commit

[robe]

In 17333:

Schema qualify all geometry casts in raster code, otherwise materialized views do not resture
Closes #4291 for PostGIS 2.3.9