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: 20060209042226.51392.qmail@web8408.mail.in.yahoo.com (view raw or flat)
Thread:
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" 
       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.

Responses

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-2014 The PostgreSQL Global Development Group