Project

General

Profile

Actions

Defect #198

closed

id sequence fails after trac import

Added by Panta Rhei almost 17 years ago. Updated almost 17 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
-
Target version:
-
Start date:
Due date:
% Done:

0%

Estimated time:
Resolution:
Affected version:

Description

after a trac import adding a new issue failed cause the 'issue_id_seq' started at 1 albeit the id 1 was taken by the
import. would be a bigger problem if the imported trac tickets are starting at 4000 eg. 4000 new tickets will be ok
in redmine. ticket 4001 breaks the app.

setting the correct nextval in the db fixed the issue.

i'm using postgresql. but i think is an db independent problem.

Actions #1

Updated by Jean-Philippe Lang almost 17 years ago

but i think is an db independent problem.

No. It works fine with mysql.
But I'll try to find a solution to this problem.

Actions #2

Updated by Panta Rhei almost 17 years ago

No. It works fine with mysql.
But I'll try to find a solution to this problem.

Ok. Great news. Thx for all your work. :)

Actions #3

Updated by Jean-Philippe Lang almost 17 years ago

Fixed in r1099. The sequence is now properly updated when using
postgres.

Actions

Also available in: Atom PDF