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

[Greg Boone]

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?

Greg

-----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?

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
-------------------------------------


_______________________________________________
fdo-users mailing list
fdo-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/fdo-users