In order to be able to use the Apache Solr module with Postgres, please change in apachesolr_search.module on line 274:

From:
AND (r.rid IN (". db_placeholders($rids) .") OR r.rid IS NULL) LIMIT 0,1", 'b', 'bid'), array_merge(array($module, $delta, $theme_key), $rids));

To:
AND (r.rid IN (". db_placeholders($rids) .") OR r.rid IS NULL) LIMIT 0 OFFSET 1", 'b', 'bid'), array_merge(array($module, $delta, $theme_key), $rids));

Comments

damien tournoud’s picture

Status: Active » Needs work

I guess you mean LIMIT 1 OFFSET 0. That said, I don't know what prevent this query from using a proper db_query_range().

jpmckinney’s picture

Status: Needs work » Fixed
jpmckinney’s picture

Version: 6.x-2.x-dev » 6.x-1.x-dev
Status: Fixed » Patch (to be ported)
jpmckinney’s picture

Status: Patch (to be ported) » Fixed

Oh, sweet, only applies to 6-2, as only 6-2 has apachesolr_search_browse.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.