[postgis-tickets] [PostGIS] #2485: [raster]: raster constraints prevent raster data from restoring

[PostGIS]

#2485: [raster]: raster constraints prevent raster data from restoring
----------------------+-----------------------------------------------------
 Reporter:  rdunklau  |       Owner:  dustymugs    
     Type:  defect    |      Status:  new          
 Priority:  critical  |   Milestone:  PostGIS 2.0.7
Component:  raster    |     Version:  trunk        
 Keywords:            |  
----------------------+-----------------------------------------------------

Comment(by robe):

 Okay that seemed to work.  I recreated the check constraints
 enforce_nodata_values_rast,
  enforce_num_bands_rast ,
   enforce_out_db_rast,
 enforce_pixel_types_rast

 as not valid in my original database, did backup and restore and things
 came back.  This was with having postgis in public, but my rasters in a
 separate schema.  Should work the same for if people install postgis in
 postgis schema.  Thinking about it more, it would speed up restore too and
 we really only need these for raster_columns and ensure forward.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2485#comment:35>
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.