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

Greg Boone greg.boone at autodesk.com
Wed Dec 19 10:56:09 EST 2007

Hey John,

I am not sure of your background, but I was wondering if you would be in a position to develop a patch to fix this issue, test it and post it for submission?


-----Original Message-----
From: fdo-users-bounces at lists.osgeo.org [mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of John Pulles
Sent: Wednesday, December 19, 2007 4:36 AM
To: FDO Users Mail List
Subject: [fdo-users] Can the FDO PostGIS provider use views?

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

fdo-users mailing list
fdo-users at lists.osgeo.org

More information about the fdo-users mailing list