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

 forget about all the above, I've concluded the best solution is as I
 proposed here:
 http://lists.osgeo.org/pipermail/postgis-devel/2015-March/024796.html 9and
 much earlier in this thread)

 , just set the search_path starting with functions affected.  Since we
 have a script that generates the functions anyway, we could have it
 eventually genenerate the ALTER FUNCTION ... needed to put in the
 search_paths and just do it for all postgis functions.

 So we'd just have a separate script file generated that does something
 like:


 {{{
 ALTER FUNCTION _raster_constraint_pixel_types(raster)
   SET search_path=pg_catalog,postgis,contrib,extensions,public;

 }}}

 starting with affected functions and if it looks good have a script that
 generates it for all functions.  This will solve both the raster specific
 issue as well as the postgis proper related ones like #3076

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