[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.5
Component:  raster    |     Version:  trunk        
 Keywords:            |  
----------------------+-----------------------------------------------------

Comment(by dustymugs):

 You can safely use the "sed" approach if the database (dumped) is well
 organized, even with custom user functions. Basically, as long as PostGIS
 is installed in its own schema and you keep it that way (not add stuff not
 part of PostGIS to that schema), you can safely make changes to the SET
 search_path.

 If you've got more complicated situations (messy), you'll need something
 more fancy. I unfortunately don't have those scripts anymore (changed
 jobs) but I used the utils/create_undef.pl script as a reference point.

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