--0-73636472-1139458946=:51389
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

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_to ur_num) values(nextval('seq_type_code'),'type_name',tourRa ngeFrom,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.
--0-73636472-1139458946=:51389
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

<div><!--StartFragment -->&nbsp;My name is shyamkumar. Right now I am using Postgres as backend for development. And J2ee technology as front end. <BR><BR>Now I have a situation like the sequence id is repeating. This applicaton is running&nbsp; since from 1999, this is the first time we get such a result. <BR><BR>I will give you more detail, <BR><BR>1. This is the code we used to create sequence "seq_type_code" <BR><BR>&nbsp;&nbsp; CREATE SEQUENCE "public"."seq_type_code" <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; INCREMENT 1&nbsp; MINVALUE 10 <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MAXVALUE 9223372036854775807&nbsp; START 10 <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CACHE 1; <BR>2&nbsp; This is query we used to insert value, here we were using the sequence. <BR>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; insert into tour_type(type_code,type_name,from_tour_num,end_to ur_num)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;& nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; values(nextval('seq_type_code'),'type_name',tourRa ngeFrom,tourRangeTo); <BR><BR>3.&nbsp; This is the result we getting, see type code is repeating here &nbsp;&nbsp;&nbsp; type_code |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp ; type_name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp ;&nbsp; | from_tour_num | end_tour_num <BR>&nbsp;&nbsp; -----------+---------------------------+---------------+-------------- <BR>&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; TEST TOUR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n bsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;& nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;& nbsp;&nbsp; 99 <BR>&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | FRANCE TEST
TOUR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs p;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;& nbsp;&nbsp; 100&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;& nbsp; 199 <BR>&nbsp;&nbsp;&nbsp; 11&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | GERMENY TEST TOUR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs p;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;& nbsp;&nbsp; 200&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;& nbsp; 299 <BR>&nbsp;&nbsp;&nbsp; 12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | HOLLAND TEST TOUR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs p;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;& nbsp;&nbsp; 300&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;& nbsp; 399 <BR><BR>I would like to know more about this, and I have to submit a detailed presentaton about this. <BR>Hope you will provide valid informations and will help us to recover from this situation. <BR><BR>Yours Sinc
erly,
<BR><BR>P.Shyamkumar <BR>Software Engineer <BR>Maxxion Systems. <BR><BR><BR></div><p>



<hr size=1>
Jiyo cricket on <a href="http://us.rd.yahoo.com/mail/in/mailcricket/*http://in.sports.yahoo.com/cricket/">Yahoo! India cricket</a><br>
<a href="http://us.rd.yahoo.com/mail/in/mailmobilemessenger/*http://in.mobile.yahoo.com/new/messenger/">Yahoo! Messenger Mobile</a> Stay in touch with your buddies all the time.
--0-73636472-1139458946=:51389--

On Thu, Feb 09, 2006 at 04:22:26AM +0000, shyam nair wrote:
What version of PostgreSQL are you running? Hopefully you've
upgraded since 1999.

When do you create this sequence? Is it possible that it got dropped
and recreated, causing it to start at the beginning again? Or that
somebody used ALTER SEQUENCE or setval() to reset the start value?

If this is a problem then why don't you have a primary key or unique
constraint on type_code? That doesn't explain why you're getting
duplicates, but at least you'd get an error when it happens. Or
do you have such a constraint and it isn't working?

Is it possible that somebody inserted a record with an explicit
type_code? That is, by specifying 10 instead of nextval('seq_type_code')?
Or that somebody updated an existing record? How many times has
the problem happened? If more than once, how often? Can you think
of anything that happened with the database around the time the
problem started? Have you enabled statement logging to see what
statements are actually being executed?

--
Michael Fuhr

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend