Re: change max_value in sequence

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: change max_value in sequence
Дата
Msg-id
24842.1220629150@sss.pgh.pa.us
Ответ на
change max_value in sequence (Claus Guttesen)
Список
Дерево обсуждения
change max_value in sequence "Claus Guttesen" <kometen@gmail.com>
Re: change max_value in sequence Tom Lane <tgl@sss.pgh.pa.us>
Re: change max_value in sequence "Scott Marlowe" <scott.marlowe@gmail.com> 
"Claus Guttesen"  writes:
> I have a table with a serial field defined with an older version of
> postgresql (ver. 7). Back then max_value was 2147483647:
> How can I increase it? By updating the max_value-field?

I think you're looking for ALTER SEQUENCE.

Note that if the column it's feeding into is int4, you'd also need to
alter the column type ...

			regards, tom lane
В списке pgsql-admin по дате отправления
Предыдущее
От: Arctic Toucan
Дата:
Следующее
От: Brad Nicholson
Дата:
FAQ