id,summary,reporter,owner,description,type,status,priority,component,severity,resolution,keywords,cc,release
10764,Not able to create new TestPlans with 1.5.2 and Trac 0.12 and PostgreSQL,michael.kroell@gmail.com,seccanj,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.\r\n\r\nAs 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.\r\n\r\nLooks like\r\n{{{\r\ntracgenericclass/trunk/tracgenericclass/util.py:66 to_utimestamp(date_obj)\r\n}}}\r\ngenerate those too large values \r\n\r\n{{{\r\nINSERT 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)\r\n}}}\r\n,defect,assigned,normal,TestManagerForTracPlugin,normal,,,,0.12