id,summary,reporter,owner,description,type,status,priority,component,severity,resolution,keywords,cc,release 3730,Queries are not type safe for PostgreSQL 8.3,Kamil Kisiel,Noah Kantrowitz,"The MasterTicketsPlugin uses queries which don't work with PostgreSQL 8.3 due to type checking. For example, the query on line 21 of model.py: {{{ cursor.execute('SELECT dest FROM mastertickets WHERE source=%s ORDER BY dest', (self.tkt.id,)) }}} returns the following error: {{{ ERROR: operator does not exist: text = integer LINE 1: select dest from mastertickets where source=1 order by dest; ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. }}} This can be corrected by adding quotes, for example: {{{ cursor.execute('SELECT dest FROM mastertickets WHERE source='%s' ORDER BY dest', (self.tkt.id,)) }}}",defect,closed,normal,MasterTicketsPlugin,normal,duplicate,,,0.11