id	summary	reporter	owner	description	type	status	priority	component	severity	resolution	keywords	cc	release
3125	installation breaks creation of reports	tekknokrat	bobbysmith007	I am using the recent version of Trac (0.11-stable_7092) and TimingEstimation Plugin with postgresql backend.\r\n\r\nWhen I activate the timingandestimation plugin and try to customize a ticket report I get this error:\r\n\r\n{{{\r\n2008-06-03 18:02:03,980 Trac[main] ERROR: duplicate key value violates unique constraint "report_pkey"\r\nTraceback (most recent call last):\r\n  File "/usr/lib/python2.5/site-packages/Trac-0.11dev_r7182-py2.5.egg/trac/web/main.py", line 423, in _dispatch_request\r\n    dispatcher.dispatch(req)\r\n  File "/usr/lib/python2.5/site-packages/Trac-0.11dev_r7182-py2.5.egg/trac/web/main.py", line 197, in dispatch\r\n    resp = chosen_handler.process_request(req)\r\n  File "/usr/lib/python2.5/site-packages/Trac-0.11dev_r7182-py2.5.egg/trac/ticket/report.py", line 93, in process_request\r\n    self._do_create(req, db)\r\n  File "/usr/lib/python2.5/site-packages/Trac-0.11dev_r7182-py2.5.egg/trac/ticket/report.py", line 141, in _do_create\r\n    "VALUES (%s,%s,%s)", (title, query, description))\r\n  File "/usr/lib/python2.5/site-packages/Trac-0.11dev_r7182-py2.5.egg/trac/db/util.py", line 50, in execute\r\n    return self.cursor.execute(sql_escape_percent(sql), args)\r\n  File "/usr/lib/python2.5/site-packages/Trac-0.11dev_r7182-py2.5.egg/trac/db/util.py", line 50, in execute\r\n    return self.cursor.execute(sql_escape_percent(sql), args)\r\nIntegrityError: duplicate key value violates unique constraint "report_pkey"\r\n}}}\r\n\r\nI tried with 1 sqlite based environment where this error does not occur.\r\nWorkaround I first had was to manually removing the t&e reports from database. After that creating/modifying of the reports worked. \r\nBut when trying to restore the reports through trac-admin upgrade it seems this gets broken because of manual deleting reports.	defect	closed	normal	TimingAndEstimationPlugin	normal	fixed	postgresql		0.11