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’, );