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

[John Pulles]

Jason Birch schreef:
> I agree that the provider should probably give access to spatial views
> also.
>
> John, regardless of whether you have the resource to fix the problem
> (which would be cool; Mateusz has a lot on his plate), please submit
> this as an issue in our Trac instance:
> http://trac.osgeo.org/fdo/wiki/SubmitTicket
>   
Jason, Greg,

I managed to register for the Trac site and am busy submitting the 
ticket with patch file attached, but the site is unfortunately a bit 
unresponse. It should be submitted now, but 
http://trac.osgeo.org/fdo/report/1 doesn't show anything.
Today I am unable to build and test the (attached) patch myself, but I 
will try to do that the coming days.

John.
> Jason 
>
> -----Original Message-----
> From: Greg Boone
> Subject: RE: [fdo-users] Can the FDO PostGIS provider use views?
>
> 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: John Pulles
> Subject: [fdo-users] Can the FDO PostGIS provider use views?
>
> 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?
> _______________________________________________
> fdo-users mailing list
> fdo-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-users
>
>
>   


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

-------------- next part --------------
Index: PgSpatialTablesReader.cpp
===================================================================
--- PgSpatialTablesReader.cpp	(revision 3639)
+++ PgSpatialTablesReader.cpp	(working copy)
@@ -195,7 +195,7 @@
 
     std::string sql("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_)' "
+                    "WHERE c.relkind IN ('r','v') 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 = '"