[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 robe):

 rdunklau,

 I think embedding the sql call will unfortunately cause other problems, so
 best bet is probably making these completely C calls. That will take some
 time so probably can't be done for 2.1.1 (probably 2.1.2)

 If you are using PostgreSQL 9.2+ you can use the new pg_dump that allows
 you to separate
 the data structure, data load calls.  As I recall I think it also allows
 you do restore separate sections.  I think the search path is only
 overwritten in the table structure create steps so if you restore the
 structure first, set your database search paths and then restore the data,
 it will work fine.

 I'll try to document this, but sadly is only a fix for 9.2+ users

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