[rt-users] Altering ticket id #

[Adrian Carter]

Got it all solved - You need to add an entry via an insert not just 
update an existing one.

Adding one with the new seed ticket and then deleting it changed the id 
to 10001.

Thanks!

Niels Bakker wrote:

>* cartera at lei.net.au (Adrian Carter) [Wed 17 Nov 2004, 17:18 CET]:
>  
>
>>I've rebuilt our RT onto a new platform with better queues etc.. but I
>>want to reset the Ticket Id to be something like 10000+ so it doesn't
>>clash with old-rt tickets.
>>
>>Can someone point me in the right direction? im checking the Wiki stuff
>>now, but can't find anything.
>>    
>>
>
>What database do you use?
>
>For PostgreSQL, connect to the RT database and issue this a few
>gazillion times:
>
>   select nextval ('tickets_id_seq');
>
>For MySQL, you can set the sequence number to arbitrary values; I've
>only used phpMyAdmin to do so.
>
>
>	-- Niels.
>
>  
>

-- 
Adrian Carter
Network Engineer
Leading Edge Internet
Direct    +61 2 6163 6162  Support 1 300 662 415
E-mail     cartera at lei.net.au