trac v0.10.4-2 doesn't work with PostgreSQL v8.3

[Karoly Molnar]

Hi,

Hardy ships with PostgreSQL v8.3 and Trac v0.10.4-2 and these two don't work together. This bug has a very detailed description on Debian and Trac and has been fixed for some time now. The issue is not present in the Trac version in Intrepid. It would be nice to fix the version in Hardy.

Links:
http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=464168
http://trac.edgewall.org/ticket/6772
http://trac.edgewall.org/changeset/6416

[Karoly Molnar (karoly-molnar)]

I added the patch and uploaded the package to my PPA for testing http://ppa.launchpad.net/karoly-molnar/ubuntu

[Karoly Molnar (karoly-molnar)]

One more fix needed.

Links:
http://trac.edgewall.org/ticket/6776

A completely different solution is to use the unpatched Trac installation and execute the following against the database:
CREATE FUNCTION pg_catalog.text(integer) RETURNS text STRICT IMMUTABLE LANGUAGE SQL AS 'SELECT textin(int4out($1));'; CREATE CAST (integer AS text) WITH FUNCTION pg_catalog.text(integer) AS IMPLICIT;"

[Karoly Molnar (karoly-molnar)]

PPA is updated too ;-)

[anatoly techtonik (techtonik)]

So, how about to mark this as fixed?