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

[[TicketQuery(status=new|assigned|reopened&component^=PostGIS&order=priority)]]


=== Closed Issues ===

[[TicketQuery(status=closed&component^=PostGIS&order=priority)]]