[fdo-users] Can the FDO PostGIS provider use views?

[John Pulles]

Hi list,

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?

Regards,
John

-- 
John Pulles
-------------------------------------
Geodan IT b.v.
Buitenhaven 27-A
5211TP 's-Hertogenbosch
-------------------------------------
Tel: +31 (0)73 - 692 5151
Fax: +31 (0)73 - 692 5150
-------------------------------------
Postadres / mailing address
President Kennedylaan 1
1079MB Amsterdam
-------------------------------------
E-mail:  john.pulles at geodan.nl
Website: http://www.geodan.nl
-------------------------------------