[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:  robe
      Type:  defect   |     Status:  closed
  Priority:  medium   |  Milestone:  PostGIS 3.0.9
 Component:  postgis  |    Version:  3.0.x
Resolution:  fixed    |   Keywords:
----------------------+---------------------------
Comment (by strk):

 Sorry you also need --upgrade switch. I could reproduce:
 {{{
 pg_restore: while PROCESSING TOC:
 pg_restore: from TOC entry 4506; 0 18661757 TABLE DATA upgrade_test_raster
 strk
 pg_restore: error: COPY failed for table "upgrade_test_raster": ERROR:
 function st_samealignment(public.raster, public.raster) does not exist
 LINE 1: SELECT NOT ST_SameAlignment(rast, coverage)
                    ^
 HINT:  No function matches the given name and argument types. You might
 need to add explicit type casts.
 QUERY:  SELECT NOT ST_SameAlignment(rast, coverage)
 CONTEXT:  PL/pgSQL function
 public.st_iscoveragetile(public.raster,public.raster,integer,integer) line
 10 at IF
 COPY upgrade_test_raster, line 1:
 "010000010000000000000000400000000000000040000000000000F03F000000000000F03F00000000000000000000000000..."
 pg_restore: warning: errors ignored on restore: 1
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5338#comment:12>
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.