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
      )");

Comments

phayes’s picture

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);
BlakeLucchesi’s picture

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.

awolfey’s picture

Status: Active » Closed (fixed)

I recently took over this module. I'm going through all the old issues and closing them if possible. I'm not making any changes other than security fixes to the Drupal 5 version.

If you would still like to see this in the Drupal 6 version, please create a new issue or reopen this one, changing the version number.

Thanks,

awolfey