Opened 2 years ago

Last modified 20 months 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: seccanj
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 2 years ago by michael.kroell@…

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

comment:2 Changed 2 years ago by seccanj

  • Status changed from new to assigned

Thanks Michael :D

I'll add your fix into next release.

comment:3 Changed 2 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?


Add Comment

Modify Ticket

as assigned The owner will remain seccanj.

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

Note: See TracTickets for help on using tickets.