Re: [rt-users] Expanding ticket numbers

[Emmanuel Lacour]

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
> #99 possible tickets? Problem is that due to spam and other
> unexpected high volume of tickets we are up to 13 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.
-
RT 4.4 and RTIR Training Sessions https://bestpractical.com/training
* Los Angeles - September, 2016

[rt-users] Expanding ticket numbers

[Joel Bergmark]

Hi,

Got a bit confused regarding expanding current ticket numbers, tried google 
this but didn't find anything clear. Ee are using #123456 hence #99 
possible tickets? Problem is that due to spam and other unexpected high volume 
of tickets we are up to 13 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 #99?

select setval('tickets_id_seq', );

Regards, Joel


-
RT 4.4 and RTIR Training Sessions https://bestpractical.com/training
* Los Angeles - September, 2016