Skip site navigation (1) Skip section navigation (2)

Please get me out of this ASAP

From: shyam nair <shyam_nair81(at)yahoo(dot)co(dot)in>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Please get me out of this ASAP
Date: 2006-02-09 04:22:26
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
 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" 
       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, 

Software Engineer 
Maxxion Systems. 

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


pgsql-bugs by date

Next:From: SatheeshDate: 2006-02-09 05:09:20
Subject: BUG #2249: unsupported frontend protocol
Previous:From: Tom LaneDate: 2006-02-09 03:41:44
Subject: Re: [PATCHES] date overflows

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group