Expanding ticket numbers

RT Users
1

Hi,

Got a bit confused regarding expanding current ticket numbers, tried google this but didn’t find anything clear. Ee are using #123456 hence #999999 possible tickets? Problem is that due to spam and other unexpected high volume of tickets we are up to 130000 already, this was much higher than anticipated after just a few months of use and soon this will increase even quicker.

Running postgresql and doing below, will previous tickets be mismatched or what will happen in this case? Or is it even necessary will it just automatically expand beyond #999999?

select setval(‘tickets_id_seq’, );

Regards, Joel

2

Le 08/06/2016 16:34, Joel Bergmark a �crit :

Hi,

Got a bit confused regarding expanding current ticket numbers, tried
google this but didn�t find anything clear. Ee are using #123456 hence
#999999 possible tickets? Problem is that due to spam and other
unexpected high volume of tickets we are up to 130000 already, this was
much higher than anticipated after just a few months of use and soon
this will increase even quicker.

I don’t know the exact limit (the size of int in perl/postgresql), but I
know RT instances with tickets numbers above million.