I have installed 6.19 on postgresql and activated the search module. I have made a very simple page and when i search for a word that is on the page i get the following error! :

warning: pg_query() [function.pg-query]: Query failed: ERROR: operator does not exist: integer || integer LINE 1: ...d), MAX(n.changed), MAX(c.last_comment_timestamp) || 1) - 12... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. in /home/sites/gmus/public_html/includes/database.pgsql.inc on line 139.
user warning: query: SELECT COUNT(*) FROM (SELECT i.type, i.sid, 5 * (7.46859455988 * SUM(i.score * t.count)) + 5 * POW(2, (GREATEST(MAX(n.created), MAX(n.changed), MAX(c.last_comment_timestamp) || 1) - 1281993312) * 6.43e-8) + 5 * (2.0 - 2.0 / (1.0 + MAX(c.comment_count) * 1)) AS score FROM search_index i INNER JOIN search_total t ON i.word = t.word INNER JOIN node n ON n.nid = i.sid LEFT JOIN node_comment_statistics c ON c.nid = i.sid WHERE n.status = 1 AND (i.word = 'vores') AND i.type = 'node' GROUP BY i.type, i.sid HAVING COUNT(*) >= 1) n1 in /home/sites/gmus/public_html/modules/search/search.module on line 958.
warning: pg_query() [function.pg-query]: Query failed: ERROR: operator does not exist: integer || integer LINE 1: ...d), MAX(n.changed), MAX(c.last_comment_timestamp) || 1) - 12... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. in /home/sites/gmus/public_html/includes/database.pgsql.inc on line 139.
user warning: query: SELECT i.type, i.sid, 5 * (7.46859455988 * SUM(i.score * t.count)) + 5 * POW(2, (GREATEST(MAX(n.created), MAX(n.changed), MAX(c.last_comment_timestamp) || 1) - 1281993312) * 6.43e-8) + 5 * (2.0 - 2.0 / (1.0 + MAX(c.comment_count) * 1)) AS score FROM search_index i INNER JOIN search_total t ON i.word = t.word INNER JOIN node n ON n.nid = i.sid LEFT JOIN node_comment_statistics c ON c.nid = i.sid WHERE n.status = 1 AND (i.word = 'vores') AND i.type = 'node' GROUP BY i.type, i.sid HAVING COUNT(*) >= 1 ORDER BY score DESC LIMIT 10 OFFSET 0 in /home/sites/gmus/public_html/modules/search/search.module on line 958.

postgresql version 8.3.11
apache 2.2.9
php 5.2.6

Is the postgresql support production ready???

Comments

superhenne’s picture

i see the same here, after updating from 6.17 to 6.19

pg 8.4.4_2
apache 2.2.16
php 5.3.3
freebsd 8.0

Pedro Gomide’s picture

The same error is happening here also. When upgrading from 6.17 to 6.19 .

DuskMan’s picture

I have the same problem http://drupal.org/node/888164

mcm.drupal’s picture

My understanding from the thread mentioned above (#888164):

  • This is a PostgreSQL specific problem
  • Caused by use of a non-standard "MySQLism" that PostgreSQL (correctly, imho) doesn't support
  • The patch in Comment #19 of thread #88164 does indeed fix the problem, at least for me (6.19 & PG 8.37).
  • Change is easy enough to do by hand, or
  • On *nix, use "patch" command to apply
jhodgdon’s picture

See http://drupal.org/node/488166 for further discussion.

pvpaneque’s picture

please i need your help , i have the same problem you describe , could you tell me where can i find this patch and how to configure it or do it , i am new using drupal, thanks