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.
pgpdS1ZfpmmKg.pgp
Description: PGP signature
