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