FDO PostGIS Provider Notes

This provider is now integrated into the main FDO release process.

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, schema, 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

If you run into problems, ask on the fdo-users mailing list and, if you think you have a bug, follow the instructions on the Ticket Submission page:

Authors / Contributors

Mateusz Loskot was the original author of this provider, working under contract to Refractions Research and the City of Nanaimo.

Bruno Scott of GeoMap is the current maintainer.

Download

Since version 3.3, the provider is now included as part of the standard FDO distribution, which can be found here:

http://fdo.osgeo.org/content/downloads

Or you can visit our download site directly:

http://download.osgeo.org/fdo/

There may also be interim unofficial beta builds available at the maintainer's website:

http://www.geomapgis.com/web/geomap-group/fdo/index.html

Installation (Windows)

• Copy the DLLs into your fdo/bin directory
• Add the following to your providers.xml file, using the correct version number for your release:

  <FeatureProvider>
    <Name>OSGeo.PostGIS.3.4</Name>
    <DisplayName>OSGeo FDO Provider for PostGIS</DisplayName>
    <Description>FDO Provider for PostGIS</Description>
    <IsManaged>False</IsManaged>
    <Version>3.4.0.0</Version>
    <FeatureDataObjectsVersion>3.4.0.0</FeatureDataObjectsVersion>
    <LibraryPath>.\PostGISProvider.dll</LibraryPath>
  </FeatureProvider>

• Ensure that your computer the Postgresql/bin directory at the beginning of the SYSTEM part of the PATH environment variable, especially for server installations like MapGuide. Alternately, determine which PostgreSQL DLLs this provider requires using depends.exe, and copy them into the fdo/bin directory.
• Reboot your computer

Connection Parameters

When you attempt to establish a connection with the PostGIS provider, you will need to fill in a number of parameters. These are described below:

Username::

Your postgresql userid

Password::

Your postgresql password

Service::

This is a connection string in the format "database@host:port" where @host and :port are optional if your database is on localhost and on the default port (5432)

Datastore::

This is the PostgreSQL schema the data is stored under. By default, all tables are stored under the "public" schema. However, this practice is not recommended as it makes postgis dump/restore procedures messy and difficult.

Open Tickets

#108

ApplySchema does not support M and Z dims for PostGIS

#117

PostGIS provider does not display attribute names in MapGuide when no PK present

#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

#325

PostGIS provider does not support Transaction correctly

#443

PostGIS defect : Only 1 geometry column of a table can be used

#515

PostGIS Defect : provider does not support editable views (using rules)

#518

PostGIS provider only support expression in SelectAggregate

#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