[postgis-tickets] [PostGIS] #5338: Dump/Restore of raster table fails on enforce_coverage_tile_rast constraint

[PostGIS]

#5338: Dump/Restore of raster table fails on enforce_coverage_tile_rast constraint
---------------------+---------------------------
 Reporter:  pramsey  |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  medium   |  Milestone:  PostGIS 3.0.9
Component:  postgis  |    Version:  3.0.x
 Keywords:           |
---------------------+---------------------------
 It seems that adding a "regular_blocking" constraint to a raster table
 will cause a pg_dump/pg_restore cycle to fail, due to the component
 functions in the constraint being out of the path during the restore
 stage.

 The attached files demonstrate the problem.

 The SH file prepares an empty DB, runs the SQL setup file, and then runs
 the dump/restore.

 The SQL file is a stripped down version of a regression test file the just
 makes the table, adds some rasters, and applies the constraint.

 The problem is visible at least as far back as 3.0 and maybe even further.
 The fact that it has been unreported this long probably speaks to how
 rarely the "regular_blocking" constraint is used.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5338>
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.