changeset 3981:82e116d515d2

another psql 8.3 compat fix
author Richard Jones <richard@users.sourceforge.net>
date Thu, 07 Aug 2008 06:05:53 +0000
parents 3167ad1c19cd
children efcea2fe69be
files CHANGES.txt roundup/backends/indexer_rdbms.py
diffstat 2 files changed, 8 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- 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)
--- 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 '\

Roundup Issue Tracker: http://roundup-tracker.org/