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

 Hi guys

 With postgres 9.4 and a mandatory pg_dump/pg_restore coming soon, I
 decided to write a quick workaround for this bug until there's a real fix.
 Hope this little bit of code is useful for others too.

 The basic idea is that since pg_dump is generating a search path that
 can't find the raster functions (because they're in public), we can move
 every raster to a temporary name, stuff the rasters into the public
 schema, pg_dump, pg_restore, then put everything back where it belongs
 afterwards.

 I've put it here: https://gist.github.com/gbb/d551c92edf2cd8371c09

 If you find any errors, please let me know.

 G

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