Please get me out of this ASAP

My name is shyamkumar. Right now I am using Postgres as backend for development. And J2ee technology as front end.

Now I have a situation like the sequence id is repeating. This applicaton is running  since from 1999, this is the
firsttime we get such a result.  

I will give you more detail,

1. This is the code we used to create sequence "seq_type_code"

   CREATE SEQUENCE "public"."seq_type_code"
       INCREMENT 1  MINVALUE 10
       MAXVALUE 9223372036854775807  START 10
       CACHE 1;
2  This is query we used to insert value, here we were using the sequence.
            insert into tour_type(type_code,type_name,from_tour_num,end_tour_num)
values(nextval('seq_type_code'),'type_name',tourRangeFrom,tourRangeTo); 

3.  This is the result we getting, see type code is repeating here     type_code |         type_name         |
from_tour_num| end_tour_num  
   -----------+---------------------------+---------------+--------------
    10        |  TEST TOUR                             |             1    |           99
    10        | FRANCE TEST TOUR             |           100   |          199
    11        | GERMENY TEST TOUR          |           200   |          299
    12        | HOLLAND TEST TOUR          |           300   |          399

I would like to know more about this, and I have to submit a detailed presentaton about this.
Hope you will provide valid informations and will help us to recover from this situation.

Yours Sincerly,

P.Shyamkumar
Software Engineer
Maxxion Systems.





---------------------------------
 Jiyo cricket on Yahoo! India cricket
Yahoo! Messenger Mobile Stay in touch with your buddies all the time.