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 first time 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.