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

 What I meant to say is what happens is the constraint gets created but
 since it can't find its mate functions, the constraint check fails and
 data load fails because the search_path is set to
 pg_catalog,schema_of_table.  It's actually a non-issue if schema_of_table
 is same schema as what postgis is installed in.

 In retrospect, it isn't quite as serious as I thought since most people
 are lazy and throw postgis and their data in public.  It's only an issue
 if you keep your data in a schema different from your postgis install.  So
 I suspect Bborie you'll be bitten by this.  Leo would be bitten too.  It's
 serious but not quite as serious and an issue for anal retentive folks :)

 As far as the view goes, the view is a non-issue the raster_columns view
 is always in same schema as postgis and I think views are treated
 differently anyway. So you are right info functions are not affected.

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