[postgis-devel] [PostGIS] #1122: exclude raster_columns from being listed in geometry_columns

PostGIS trac at osgeo.org
Wed Jan 18 23:51:45 PST 2012


#1122: exclude raster_columns from being listed in geometry_columns
---------------------+------------------------------------------------------
 Reporter:  robe     |       Owner:  robe         
     Type:  defect   |      Status:  new          
 Priority:  medium   |   Milestone:  PostGIS 2.0.0
Component:  postgis  |     Version:  trunk        
 Keywords:           |  
---------------------+------------------------------------------------------

Comment(by robe):

 no topology tables do not annoy me.  Those actually make sense to be
 listed in geometry_columns because they really are geometry columns you
 can query like any other and are real bonafied geometry tables.
 raster_columns is a view now so there is doubly no point in having it
 listed.

 The main issue with raster_columns why it is different and useless to list
 is that its a mixed bag of mbrs so there is no consistency in the srid.
 It will always be unknown.  I can't think of a reason why a gis client
 would even care about this column because if they cared about raster,
 they'd go straight for the raster_columns system catalog and be displaying
 the extent.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1122#comment:5>
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-devel mailing list