# HG changeset patch
# User Richard Jones <richard@users.sourceforge.net>
# Date 1218089153 0
# Node ID 82e116d515d23d6f78afa9138266f7960e5068d6
# Parent  3167ad1c19cddfd95e101e66a782d4f1e32b149d
another psql 8.3 compat fix

diff -r 3167ad1c19cd -r 82e116d515d2 CHANGES.txt
--- a/CHANGES.txt	Thu Aug 07 05:59:18 2008 +0000
+++ b/CHANGES.txt	Thu Aug 07 06:05:53 2008 +0000
@@ -7,7 +7,8 @@
 - xml-rpc security checks and tests across all backends (sf #1907211)
 - Send a Precedence header in email so autoresponders don't
 - Fix mailgw total failure bounce message generation (thanks  Bradley Dean)
-- Fix for postgres 8.3 compatibility (and bug) (sf patch #2030479)
+- Fix for postgres 8.3 compatibility (and bug) (sf patch #2030479 and bug
+  #1959261)
 - Fix for translations (sf patch #2032526)
 - Fire reactors after file storage is all done (sf patch #2001243)
 - Allow negative ids other than -1 for item generation (sf patch #1982481)
diff -r 3167ad1c19cd -r 82e116d515d2 roundup/backends/indexer_rdbms.py
--- a/roundup/backends/indexer_rdbms.py	Thu Aug 07 05:59:18 2008 +0000
+++ b/roundup/backends/indexer_rdbms.py	Thu Aug 07 06:05:53 2008 +0000
@@ -1,4 +1,4 @@
-#$Id: indexer_rdbms.py,v 1.15 2006-10-04 01:12:00 richard Exp $
+#$Id: indexer_rdbms.py,v 1.16 2008-08-07 06:05:53 richard Exp $
 ''' This implements the full-text indexer over two RDBMS tables. The first
 is a mapping of words to occurance IDs. The second maps the IDs to (Class,
 propname, itemid) instances.
@@ -38,6 +38,11 @@
         if mime_type != 'text/plain':
             return
 
+        # Ensure all elements of the identifier are integers 'cos the itemid
+        # column is varchar even if item ids may be numbers elsewhere in the
+        # code. ugh.
+        identifier = map(str, identifier)
+
         # first, find the id of the (classname, itemid, property)
         a = self.db.arg
         sql = 'select _textid from __textids where _class=%s and '\