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