[postgis-devel] [PostGIS] #1813: geometry_columns table fails to take into account the current schema search_path

[PostGIS]

#1813: geometry_columns table fails to take into account the current schema
search_path
---------------------+------------------------------------------------------
 Reporter:  chander  |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  medium   |   Milestone:  PostGIS 2.0.1
Component:  postgis  |     Version:  2.0.x        
 Keywords:           |  
---------------------+------------------------------------------------------
 The current geometry_columns table often lists tables that might not exist
 for a user (or might not be visible to them) because it fails to take into
 account the users current search path.

 I believe the SQL code for the view should have the following appended to
 it:

  and pg_catalog.pg_table_is_visible(c.oid)

 This would result in spatial_ref_sys only displaying information for
 tables that exist in the current search_path.

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