[fdo-trac] #764: Update PostGIS provider to support PostGIS 2.0

FDO trac_fdo at osgeo.org
Mon May 30 23:18:42 EDT 2011


#764: Update PostGIS provider to support PostGIS 2.0
--------------------------------+-------------------------------------------
   Reporter:  RockyLiu          |       Owner:  gregboone      
       Type:  defect            |      Status:  new            
   Priority:  major             |   Milestone:  3.7.0          
  Component:  PostGIS Provider  |     Version:  3.7.0          
   Severity:  3                 |    Keywords:  PostGIS 2.0 SQL
External_id:                    |  
--------------------------------+-------------------------------------------
 In the 'postgis.sql' of some previous PostGIS versions(e.g. 1.2~1.4),
 names of some functions are proposed to change. New equivalent functions
 with better names are added, and old functions are still maintained.
 For example, in the 'postgis.sql' of version 1.5:

 postgis.sql (version 1.5)
 ------------------------------------------------------------------

 -- Deprecation in 1.2.3

 CREATE OR REPLACE FUNCTION intersects(geometry,geometry)
         RETURNS boolean
         AS '$libdir/postgis-1.5'
         LANGUAGE 'C' IMMUTABLE STRICT;

 -- PostGIS equivalent function: intersects(geometry,geometry)

 CREATE OR REPLACE FUNCTION _ST_Intersects(geometry,geometry)
         RETURNS boolean
         AS '$libdir/postgis-1.5','intersects'
         LANGUAGE 'C' IMMUTABLE STRICT
 -----------------------------------------------------------------

 In PostGIS 2.0, most of the old deprecatory functions are removed(in above
 example, only _ST_intersects is avail in 2.0). But the PostGIS provider
 still use these old functions to setup the SQL filter.

 So, we should modify file: 'FdoRdbmsPostGisFilterProcessor.cpp' to use new
 functions if the version of PostGIS is 2.0 or later.

 The modification have been finished locally and will be submit if the
 review is passed.

-- 
Ticket URL: <http://trac.osgeo.org/fdo/ticket/764>
FDO <http://fdo.osgeo.org/>
Feature Data Objects


More information about the fdo-trac mailing list