location.module doesn't work with PostgreSQL. Walkah pointed out the issue to me. I was also wondering if PostgreSQL supports SQL trig functions. The SQL in some of the queries from location.module and location.inc (as well as some of the location.xx.incs) use very specific SQL functions. I'm not sure, though, whether all of those SQL functions are Postgres-compatible. Anyone want to check? In the meantime, I'll replace the REPLACEs.

-Ankur

Comments

ankur’s picture

ankur commented
Status: Active » Fixed

Fixed in DRUPAL-4-6 and HEAD.

To see what changed in the location.module file (the only affected file), please see:
http://cvs.drupal.org/viewcvs/drupal/contributions/modules/location/loca...

I'd still like to find out whether the queries used in location_search_form_page() (location.module) and whether the SQL generated by the function earth_distance_sql() (earth.inc) are Postgres-compatible.

-Ankur

Anonymous’s picture

(not verified) commented
Anonymous’s picture

(not verified) commented
Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)