On Dec 7, 2006, at 12:30 PM, Jen wrote: > > I am testing our new Trac system. I created a ticket to test the > display and workflow. > > If I delete this ticket and create a new one, will the new ticket > id be > 1, or will it be 2 even though ticket 1 no longer exists? > > And, what if we have, say, 10 tickets, and I remove ticket #2.... will > the subsequent ticket numbers all move down to fill the blank, or will > the sequence then be 1, 3, 4, 5 ...?
It depends on the DB backend. Postgres keeps SERIAL sequences no matter what, so numbers will never be reused. With SQLite it uses the last ID plus 1, so if you delete tickets from the end, those numbers will get reused (but not numbers from the "middle"). --Noah --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~----------~----~----~----~------~----~------~--~---
