Bug report #4052
Switch to ST_ prefixed functions in PostGIS provider
|Affected QGIS version:||Regression?:||No|
|Operating System:||Easy fix?:||No|
|Pull Request or Patch supplied:||No||Resolution:||fixed|
|Crashes QGIS or corrupts data:||Copied to github as #:||14038|
non-ST prefixed functions are about to be dropped from PostGIS (2.0)
ST_ version were available since postgis 1.2
previous debian stable (lenny) shipped postgis 1.3
it seems to me that nothing prevents qgis from switching to use ST_, and document requirement of PostGIS-1.2 or higher
NOTE that a noticable exception to this is 'geometrytype', which will be kept as non-ST prefixed (as the ST_ prefixed version is documented to require different output from ISO).
PostGIS 2.0 is due for September so I think it's worth fixing for the 1.7 branch too.
I'll take careful testing of PostGIS-1.2 and PostGIS-2.0.
I could work on this if you agree on the principle.