On Sat, Jan 8, 2011 at 6:10 AM, melzaiady <melzai...@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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs