[rt-users] RT MAX TICKET ID

[ktm at rice.edu]

On Tue, Jun 11, 2013 at 03:57:00PM -0400, romain.pelissier at bell.ca wrote:
> Hi,
> Maybe that sound as a stupid question but can you tell me what is the MAX value for a ticket ID? Is there a end-of-the-world ticket id limit?
> I have been asked for this question and pretty sure that at 100000 it will still works but can find a way to confirm this.
> If anyone can tell me it will be greatly appreciated.
> Thanks!
> 
> Romain Pelissier

Hi Romain,

According to the DB schema for PostgreSQL the ticket ID is defined to be
an integer which in SQL has a maximum of (2^31 - 1) which is the max. You
would need to log a lot of tickets to reach that. I do not know if there
are coding assumptions within RT that would preclude increasing that to
a bigint with a max of (2^63 -1).

Cheers,
Ken