wiki:FdoPostGISNotes

Version 4 (modified by jbirch, 17 years ago) ( diff )

--

FDO PostGIS Provider Notes

This provider is a "work in progress", and this page is used to track relevent items during development, and will eventually turn into a usage notes page as the provider matures.

If you are using the PostGIS provider, please be aware of these limitations:

  • Spatial tables must have entries in the geometry_columns table
  • The PostGIS provider currently does not support anything but lowercase identifiers consistently (database, table, column)
  • If you add a table in MapGuide which does not contain a primary key, no columns will show up in the properties list
  • You need to run VACUUM ANALYSE on your spatial tables regularly if you want them to work well

Installation

  • Copy the three DLL files into your fdo/bin directory
  • Add the following to your providers.xml file:
  <FeatureProvider>
    <Name>OSGeo.PostGIS.3.2</Name>
    <DisplayName>OSGeo FDO Provider for PostGIS</DisplayName>
    <Description>FDO Provider for PostGIS</Description>
    <IsManaged>False</IsManaged>
    <Version>3.2.0.0</Version>
    <FeatureDataObjectsVersion>3.2.0.0</FeatureDataObjectsVersion>
    <LibraryPath>.\PostGISProvider.dll</LibraryPath>
  </FeatureProvider>

  • Ensure that your computer has a version of the Postgresql/bin directory at the beginning of the SYSTEM part of the PATH environment variable, especially for server installations like MapGuide
  • Reboot your computer

Current Outstanding Issues

#1003
Materialized Views not filtered

Closed Issues

#77
Added PostGIS to Thirdparty BAT scripts
#94
Generate extent for features assigned to default spatial context
#104
PostGIS provider cannot insert features with geometry
#106
PostGIS provider cannot delete a feature class
#108
ApplySchema does not support M and Z dims for PostGIS
#114
PostGIS Provider does not support theming in MapGuide Studio
#115
Missing quoting for names in ApplySchema command
#116
Cursor names seem to be not unique
#117
PostGIS provider does not display attribute names in MapGuide when no PK present
#118
PostGIS provider appears to be double-quoting geometry columns
#119
PostGIS missing quotes for columns in queries
#120
PostGIS ungracefully handles structural problems in a database
#121
PostGIS extents calculations do not appear to be working
#122
Add PostGIS Samples to SVN
#144
Add PostGIS Provider to top level build processes
#171
Fdo Postgis Autogenated identity property is mandatory
#178
PostGIS : Can't insert in a non-feature class
#201
PostGIS provider doesn't use views in geometry_columns
#202
PostGIS provider doesn't use views in geometry_columns
#232
Fdo Postgis null and not null filter does not work
#233
Fdo Postgis in and not in filter does not work
#234
Fdo Postgis currently does not support anything but lowercase identifiers
#235
Fdo Postgis Exception with insert
#236
Fdo Postgis does not support non spatial classes
#241
Implement Support for SelectAggregates, SpatialExtents and Count
#310
PostGIS provider : change class naming convention without ~
#311
PostGIS provider : mismatch between FdoGeometricTypes and FdoGeometryType
#312
PostGIS provider : remove boost_date_time dll dependency
#313
PostGIS provider : can't filter,insert or update date/datetime
#314
PostGIS provider : check-out/check-in crashes Autodesk Map
#318
[REVIEW] PostGIS provider patch 3.4 from Bruno Scott
#324
PostGIS provider : Insert and update geometry failed when a table has a srid
#325
PostGIS provider does not support Transaction correctly
#328
PostGIS FdoIInsert::Execute always returns NULL
#329
PostGIS FdoISQLCommand::GetSQLStatement always returns NULL
#337
PostGIS defect : insert,update more than one column failed on dates
#338
PostGIS defect : insert with srid -1 failed
#339
PostGIS defect : Srid is not set properly when creating a FeatureClass
#341
PostGIS defect : SelectAggregate does not support DISTINCT
#344
PostGIS Defect : selecting features does not work when primary index is not the first index ceated
#345
PostGIS Defect : updating or inserting a null date failes
#346
PostGIS Defect : provider does not support views to PostGIS
#353
FdoPostGIS SpatialExtent function is not implemented
#354
PostGIS Defect : cursor name conflict make provider crash
#394
PostGIS Defect : Describe schema fails when advanced types present
#443
PostGIS defect : Only 1 geometry column of a table can be used
#513
PostGIS provider Capabilities does not reflect reality
#515
PostGIS Defect : provider does not support editable views (using rules)
#517
PostGIS provider does not support timestampz column type
#518
PostGIS provider only support expression in SelectAggregate
#527
FDO Provider for Postgis - MapGuide 2009 Final Release
#530
Connections with PostGIS versions > 1.3.4 do not work
#544
PostGIS Provider fails to return autogenerated ID from insert feature reader
#546
PostGIS Provider fails on spatial query - unsupported geometry type error
#553
PostGIS Transaction kills connection
#574
FDO Provider for PostGIS not connecting in the MGOS 2.x
#610
PostgreSQL views have no attributes in FDO 3.4.1
#694
Undefined symbols in libPostGISProvider-3.5.0.so
#755
PostGIS: Remove deprecated PostGIS files
#764
Update PostGIS provider to support PostGIS 2.0
#783
[FDO VS2010 Porting]Updated UnitTestPostGIS reference directories setting in Sandbox/V100
#813
Fix buffer overflow in FDO PostGis provider
#814
Fix buffer overflow in FDO PostGis provider
#823
Fix PostGIS unit test project setting
#923
PostGis: cannot handle constraint check clause like '10'::integer

Note: See TracWiki for help on using the wiki.