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

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

Who's to blame?

(Jason thinks this should be thank)

• ​Mateusz Loskot - if you need direct contact, I'm the author of OSGeo FDO Provider for PostGIS.

Prerequisites

This provider is compiled against FDO 3.2.2, which means that it requires MapGuide Open Source 1.2. It should also work with Autodesk MapGuide Enterprise 2008, and AutoCAD Map 3D 2008, but has not been thoroughly tested.

Current testing is being done against PostgreSQL 8.2 and PostGIS 1.3.1. It should work with previous versions, as we are using older-style SQL functions. However, you will require a copy of the 8.2 DLLs to use this provider.

This provider is currently only compatible with Windows. If you would like to help out with creating a Linux build, please let us know.

Download

The current build of the provider (Changeset 3317 with the patch from #118 applied) is available here:

​http://www.jasonbirch.com/fdopostgis/fdopostgis_323_alpha_3317a.zip

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 8.2.4 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

#1003

Materialized Views not filtered