
gdt at ir
Jul 1, 2009, 7:42 AM
Views: 218
Permalink
|
|
postgresql83 and mastertickets
|
|
I upgraded a trac server to new hardware and in the process took pgsql From 8.1 to 8.3. Viewing of individual tickets failed: Trac detected an internal error: OperationalError: ERROR: operator does not exist: text = integer LINE 1: SELECT dest FROM mastertickets WHERE source=1222 ORDER BY de... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. I will look through the code and try to send a fix but it looks like there's a missing cast of the fields should be of type integer. With postgresql82 it seems to work.
|