[BUGS] Please get me out of this ASAP

[shyam nair]

 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 Sinc erly,

P.Shyamkumar
Software Engineer
Maxxion Systems.

---

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