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

 In retrospect, it isn't quite as serious as I thought since most people
 are lazy and throw postgis and their data in public.

 From my experience, many people would be bitten by this. Not because they
 throw all postgis data in its own schema, but because there can be postgis
 data spread among many of them.

   I always emit the SQL from pg_restore (pg_dump in custom format) and
 make my necessary changes (usually with a shell script).

 As a temporary workaround, could you provide an example of such a script ?
 The only thing I could think of was to "sed" the SET search_path command
 to include public as well, but I'm sure there could be many unforeseen
 side-effects (for user-defined functions, for exemple).

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