[fdo-trac] #201: PostGIS provider doesn't use views in geometry_columns

[FDO]

#201: PostGIS provider doesn't use views in geometry_columns
--------------------------------+-------------------------------------------
   Reporter:  jpulles           |       Owner:  mloskot
       Type:  enhancement       |      Status:  new    
   Priority:  major             |   Milestone:  3.3.0  
  Component:  PostGIS Provider  |     Version:  3.2.0  
   Severity:  3                 |    Keywords:         
External_id:                    |  
--------------------------------+-------------------------------------------
 It seems that the FDO PostGIS provider doesn't show views when listing
 the feature sets that contain geometry.
 The source file PgSpatialTablesReader.cpp has an Open function that uses
 the following query to get a list of 'table' names:

 SELECT n.nspname AS schemaname, c.relname AS tablename
 FROM pg_class c, pg_namespace n, geometry_columns g
 WHERE c.relkind = 'r' AND c.relname !~ '^(pg_|sql_)'
 AND c.relnamespace = n.oid AND n.nspname = g.f_table_schema
 AND c.relname::TEXT = g.f_table_name::TEXT
 AND n.nspname = '<current schema>' GROUP BY schemaname, tablename

 For views, the relkind column has a value of 'v', thus views are NOT
 selected by this query. Shouldn't the PostGIS provider enable usage of
 views that are present in the geometry_columns table?

 The patch is attached but has not yet been tested. At least the sql
 statement works in PgAdmin, and the search term geometry_columns doesn't
 occur in any other cpp file of the PostGIS driver.

-- 
Ticket URL: <http://trac.osgeo.org/fdo/ticket/201>
FDO <http://fdo.osgeo.org/>
Feature Data Objects