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

John Pulles john.pulles at geodan.nl
Wed Dec 19 04:35:47 EST 2007

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?


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

More information about the fdo-users mailing list