Re: BUG #5809: bigserial duplicate value - Mailing list pgsql-bugs

From Robert Haas
Subject Re: BUG #5809: bigserial duplicate value
Date
Msg-id AANLkTi=B3M1REf61b_LbrQ=ny-sd4pWyVG0amLr=wb6M@mail.gmail.com
Whole thread Raw
In response to Re: BUG #5809: bigserial duplicate value  (melzaiady <melzaiady@yahoo.co.uk>)
List pgsql-bugs
On Sat, Jan 8, 2011 at 6:10 AM, melzaiady <melzaiady@yahoo.co.uk> wrote:
>
> http://postgresql.1045698.n5.nabble.com/file/n3332998/data1.jpg
>
> this picture of screen you can new sequence of value.
>
> now how can i slove this problem and this field dont start new squences in
> any time ?

It's pretty hard to tell what's actually going on here, but your
original complaint is that you're getting duplicate values, and there
are no duplicate values shown in this picture.  It's not even clear
that the sequence is resetting itself -- it might just be that the
values are sorted as strings rather than integers.  But if it is
getting reset, it's not happening magically behind the scenes - some
human being or program is resetting it.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-bugs by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: BUG #5831: Splitting string into char array with string_to_array does not work
Next
From: Robert Haas
Date:
Subject: Re: BUG #5816: index not used in function