Ticket #346 (closed defect: fixed)

Opened 1 year ago

Last modified 2 months ago

PostGIS Defect : provider does not support views to PostGIS

Reported by: bscott Assigned to:
Priority: major Milestone: 3.5.0
Component: PostGIS Provider Version: 3.2.0
Severity: 3 Keywords:
Cc: External ID:

Description

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.

Attachments

postgis_trunk_patch346.patch (1.4 kB) - added by bscott on 05/30/08 11:34:19.

Change History

05/30/08 11:34:19 changed by bscott

  • attachment postgis_trunk_patch346.patch added.

09/16/08 12:26:28 changed by mwtoews

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").

04/16/09 23:51:58 changed by mwtoews

  • summary changed from PostGIS Defect : provider does not support views to PostGIS Defect : provider does not support editable views (using rules).
  • milestone changed from 3.4.0 to 3.5.0.

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.

04/29/09 04:01:12 changed by bscott

  • summary changed from PostGIS Defect : provider does not support editable views (using rules) to PostGIS Defect : provider does not support views to PostGIS.

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.

04/29/09 05:40:06 changed by bscott

  • status changed from new to closed.
  • resolution set to fixed.

04/29/09 06:19:51 changed by mloskot

  • status changed from closed to reopened.
  • resolution deleted.

04/29/09 06:19:57 changed by mloskot

  • owner deleted.
  • status changed from reopened to new.

04/29/09 06:20:02 changed by mloskot

  • status changed from new to closed.
  • resolution set to fixed.