id,summary,reporter,owner,description,type,status,priority,component,severity,resolution,keywords,cc,release
7460,Wrong schema definition for PostgreSQL,mitar,coderanger,Schema defintion for `mastertickets` table is not precise and so plugin fails on PostgreSQL with:\r\n\r\n{{{\r\nProgrammingError: operator does not exist: text = integer\r\nLINE 1: SELECT dest FROM mastertickets WHERE source=32 ORDER BY dest\r\n                                                   ^\r\nHINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.\r\n}}}\r\n\r\nThis select query is in:\r\n\r\n{{{\r\n File "/usr/lib/pymodules/python2.5/mastertickets/model.py"_ line 22_ in  __init__  \r\n}}}\r\n\r\nThe problem is that columns are not defined with integer type. I am attaching a patch which fixes this.,defect,closed,normal,MasterTicketsPlugin,normal,fixed,,mmitar@gmail.com,0.11