Postgresql doesn't do REPLACE INTO
kjcole - January 16, 2009 - 22:39
| Project: | GeoNames |
| Version: | 6.x-1.1 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
| Issue tags: | PostgreSQL |
Jump to:
Description
geonames.module uses "REPLACE INTO" which appears to be a MySQL-only bit.
The How to write PostgreSQL-friendly SQL page on the Drupal Groups site suggests that w/ Drupal 6, this will become more of an issue and offers some suggestions on code to replace MySQL-only code...
#1
Could you please repair this bug! I would like to use this module, but my drupal runs with postgresql and I gave the same error messages.
Thanks!
#2
I happen to have just replaced this code with a truncate/add - so I think this issue is fixed
http://cvs.drupal.org/viewvc.py/drupal/contributions/modules/geonames/ge...
#3
Automatically closed -- issue fixed for 2 weeks with no activity.