Re: BUG #5809: bigserial duplicate value

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: BUG #5809: bigserial duplicate value
Дата
Msg-id AANLkTi=B3M1REf61b_LbrQ=ny-sd4pWyVG0amLr=wb6M@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #5809: bigserial duplicate value  (melzaiady <melzaiady@yahoo.co.uk>)
Список 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 по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: BUG #5831: Splitting string into char array with string_to_array does not work
Следующее
От: Robert Haas
Дата:
Сообщение: Re: BUG #5816: index not used in function