[postgis-tickets] [PostGIS] #2512: [raster]: raster_columns should support foreign tables and materialized views

PostGIS trac at osgeo.org
Thu Oct 17 04:49:04 PDT 2013


#2512: [raster]: raster_columns should support foreign tables and materialized
views
--------------------+-------------------------------------------------------
 Reporter:  robe    |       Owner:  dustymugs    
     Type:  defect  |      Status:  new          
 Priority:  medium  |   Milestone:  PostGIS 2.1.1
Component:  raster  |     Version:  2.1.x        
 Keywords:          |  
--------------------+-------------------------------------------------------
 I haven't tested this, but looking at the raster_columns view it looks
 like it's missing relkind for materialized views and foreign tables
 similar to issue in #2511


 should be changed to
 {{{
 c.relkind = 'r'::"char" OR c.relkind = 'v'::"char" OR c.relkind =
 'm'::"char" OR c.relkind = 'f'::"char"
 }}}

 unfortunately foreign tables and materialized views never have constraints
 so the ability to get the other relevant info will be limited non-
 existent.

 I wouldn't bother pushing to 2.0 since I think the user base of people
 that would try to use a PostgreSQL FDW in 9.2 and using raster and caring
 about raster_columns is really small if existent at all.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2512>
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.


More information about the postgis-tickets mailing list