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:

{{{
ProgrammingError: operator does not exist: text = integer
LINE 1: SELECT dest FROM mastertickets WHERE source=32 ORDER BY dest
                                                   ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.
}}}

This select query is in:

{{{
 File ""/usr/lib/pymodules/python2.5/mastertickets/model.py"", line 22, in  __init__  
}}}

The 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@…	0.11