Opened 14 years ago
Closed 7 years ago
#764 closed defect (fixed)
Update PostGIS provider to support PostGIS 2.0
Reported by: | RockyLiu | Owned by: | gregboone |
---|---|---|---|
Priority: | major | Milestone: | 3.7.0 |
Component: | PostGIS Provider | Version: | 3.7.0 |
Severity: | 3 | Keywords: | PostGIS 2.0 SQL |
Cc: | External ID: |
Description
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.