Bug report #4052

Switch to ST_ prefixed functions in PostGIS provider

Added by Sandro Santilli about 8 years ago. Updated almost 8 years ago.

Status:Closed
Priority:Normal
Assignee:Jürgen Fischer
Category:Data 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

Description

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.

History

#1 Updated by Jürgen Fischer about 8 years ago

what's missing in 970737061582e5443769f260ee13e32a792792b1? AFAICS the switch is already done.

#2 Updated by Jürgen Fischer about 8 years ago

  • Assignee set to Jürgen Fischer

#3 Updated by Sandro Santilli about 8 years ago

You're probably right. Was it also backported to 1.7 ?

#4 Updated by Tim Sutton almost 8 years ago

  • Target version changed from Version 1.7.1 to Version 1.7.2

#5 Updated by Giovanni Manghi almost 8 years ago

  • Target version changed from Version 1.7.2 to Version 1.7.3

#6 Updated by Giovanni Manghi almost 8 years ago

  • Target version changed from Version 1.7.3 to Version 1.7.4

#7 Updated by Sandro Santilli almost 8 years ago

  • Pull Request or Patch supplied set to No
  • Status changed from Open to Closed
  • Resolution set to fixed

I'm using 1.7.3 with no problems, so this seems good.

Also available in: Atom PDF