Changing starting ticket number


#1

We are finally up, but we are moving from a different help desk to
this current one. Is there a way for us to start the ticket numbers at
the numbers where we left off at?

Thanks,

Charlie


#2

http://wiki.bestpractical.com/view/SetStartingIdOn Wed, Sep 17, 2008 at 2:05 AM, Charlie Reddington charlie.reddington@gmail.com wrote:

We are finally up, but we are moving from a different help desk to
this current one. Is there a way for us to start the ticket numbers at
the numbers where we left off at?

Thanks,

Charlie


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Best regards, Ruslan.


#3

Hi, i’m trying to change the starting ticket number to a higher number.
I have a RT 4.4.3 brand new installation on a Centos 7 using the Centos installation guide from the wiki.

I’m issuing these commands:

sudo -u postgres psql - to enter the posgres shell and enter the password to authenticate

then I issue

postgres=# SELECT setval(‘tickets_id_seq’, 20800);

and get this error

ERROR: relation “tickets_id_seq” does not exist
LINE 1: SELECT setval(‘tickets_id_seq’, 20800);
^
postgres=#

Would you guys be able to help interpret this?