Not able to create new TestPlans with 1.5.2 and Trac 0.12 and PostgreSQL

[michael.kroell@…]

With Trac 0.12 and PostgreSQL there is a datatype issue. For example when trying to create a TestPlan Pg won't store it because the value for the "time" column does not fit into the integer type range.

As a work-around I changed the data type on my local instance using "alter table testplan alter column time type bigint;" but I guess resorting to bigint is not the nicest resolution.

Looks like

tracgenericclass/trunk/tracgenericclass/util.py:66 to_utimestamp(date_obj)

generate those too large values

INSERT INTO testplan (id,catid,page_name,name,author,time,contains_all,freeze_tc_versions) VALUES (E'42',E'43',E'TC_TT43',E'testtestplan',E'mkroell',1357563642946958,1,0)

[michael.kroell@…]

Btw, just had to convert the type of testcasehistory.time too ;-)

[Roberto Longobardi]

Thanks Michael :D

I'll add your fix into next release.

[michael.kroell@…]

I think there were more time related columns to be updated. Also, is it really a fix and not a workaround? Is it really required to have bigint there?

~michael