PostGIS provider doesn't use views in geometry_columns

[jpulles]

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.

[jpulles]

The patch has been tested, en shows views in MapGuide Studio. Please submit to svn.