PostgreSQL support
phayes - July 4, 2008 - 03:56
| Project: | Fuzzy Search |
| Version: | 5.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
Description
here is the code to allow this module to be installed in postgresql environment
db_query("CREATE TABLE search_index_queue (
nid serial PRIMARY KEY,
module character(60) NOT NULL,
\"timestamp\" integer NOT NULL
)");
db_query("CREATE TABLE search_fuzzy_index (
id serial PRIMARY KEY,
nid integer NOT NULL,
word_id integer NOT NULL,
ngram varchar(6) NOT NULL,
completeness double precision NOT NULL,
score numeric(8,2) NOT NULL
)");
#1
You also need to modify line 216 to use proper drupal database abstraction.
Should be:
$query = db_query_range("SELECT nid FROM {search_index_queue}", 0, 150);#2
Thanks for your help on this. As I am putting in more work to this module I will make sure to include this in the next release.