Ticket #346 (closed defect: fixed)

Opened 2 years ago

Last modified 10 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/2008 11:34:19 AM.

Change History

05/30/2008 11:34:19 AM changed by bscott

  • attachment postgis_trunk_patch346.patch added.

09/16/2008 12:26:28 PM 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/2009 11:51:58 PM 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/2009 04:01:12 AM 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/2009 05:40:06 AM changed by bscott

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

04/29/2009 06:19:51 AM changed by mloskot

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

04/29/2009 06:19:57 AM changed by mloskot

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

04/29/2009 06:20:02 AM changed by mloskot

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