PostGIS Defect : provider does not support views to PostGIS

[bscott]

If you have a view defined in postgis, you can not use it as the provider does not list it in available featureclass or class.

[Mike Toews]

I've tested linking to views using Version 3.2 (​http://www.geomapgis.com/web/geomap-group/fdo/PostGIS/2008-03-07/FdoPg32L.zip) in AutoCAD Map 2008.

My findings are:

• Views can be linked as read-only, and the view must be added in the geometry_columns table. This is a fine solution if you don't want to modify the data (does this work for Mapguide users?).
• Editable views are not currently possible from AutoCAD Map 2008. I have also tested views with rules for insert and update events, which are editable from ODBC (i.e., MS Access), but are not through FDO (message: "Feature source cannot be updated").

[Mike Toews]

Title updated to correct the issue more clearly. Read-only view work as expected.

Note that there is a potential work-around for #394 if this ticket is fixed. E.g., create insert/update/delete rules for the view in PostgreSQL.

[bscott]

The version you tested From Geomap add already the patch 346 applied. It's why you were able to query views. So the title was correct "PostGIS Defect : provider does not support views to PostGIS" and i'm creating a new defect "PostGIS Defect : provider does not support editable views (using rules)" I'm applying the patch to trunck and closing this one so there won't be any confusion.