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.