Re: changes sequences to unique

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: changes sequences to unique
Дата
Msg-id Pine.BSF.4.21.0106061144270.16690-100000@megazone23.bigpanda.com
обсуждение исходный текст
Ответ на changes sequences to unique  (Dave Stokes <dave@greatgeek.com>)
Список pgsql-admin
On Wed, 6 Jun 2001, Dave Stokes wrote:

> I have a sequence that I 'thought' was providing unique numbers but is
> not.  Is there someway to turn on unique-ness?  Should I reload after
> adding unique to the sequence?  Any other thoughts on digging my way out
> of the problem?

They should provide unique numbers.  You could get non-unique values in
a column with a sequence default if you manually insert values (the
sequence wouldn't know about these).  Can you give a sequence of events
from a blank start to replicate what you're seeing?



В списке pgsql-admin по дате отправления:

Предыдущее
От: Dave Stokes
Дата:
Сообщение: changes sequences to unique
Следующее
От: Tom Lane
Дата:
Сообщение: Re: changes sequences to unique