Database error in postgres
|Reported by:||anonymous||Owned by:||Jonas Borgström|
Trac detected an internal error: ERROR: Unable to identify an operator '=' for types 'text' and 'integer' You will have to retype this query using an explicit cast
This is both in postgres 7.2.1 and 7.4.8 whic are on the old side, but I suspect it'll happen in newer versions too.
It's easily resolved by changing the id field in the attachment table from a test field to an integer.
Is there a good reason why the id field is text in attachment but integer in ticket and ticket_custom?
I'll be happy to provide my email when Trac provides email munging.