Opened 11 years ago

Last modified 11 years ago

#10764 assigned defect

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

Reported by: michael.kroell@… Owned by: Roberto Longobardi
Priority: normal Component: TestManagerForTracPlugin
Severity: normal Keywords:
Cc: Trac Release: 0.12


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/ 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)

Attachments (0)

Change History (3)

comment:1 Changed 11 years ago by michael.kroell@…

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

comment:2 Changed 11 years ago by Roberto Longobardi

Status: newassigned

Thanks Michael :D

I'll add your fix into next release.

comment:3 Changed 11 years ago by 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?


Modify Ticket

Change Properties
Set your email in Preferences
as assigned The owner will remain Roberto Longobardi.

Add Comment

E-mail address and name can be saved in the Preferences.

Note: See TracTickets for help on using tickets.