Re: BUG #5809: bigserial duplicate value

On Sat, Jan 8, 2011 at 6:10 AM, melzaiady <melzaiady(at)yahoo(dot)co(dot)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