Serial column has suddenly stopped working

Поиск
Список
Период
Сортировка
От Malcolm Warren
Тема Serial column has suddenly stopped working
Дата
Msg-id 41C17BC8.6060300@villeinitalia.com
обсуждение исходный текст
Ответы Re: Serial column has suddenly stopped working
Список pgsql-general
I have been using a serial column in my most important postgres table
for a couple of years.

But today it has suddenly started assigning zero instead of the next
number, which clearly is causing chaos.
I have restarted Postgres, but it has not solved the problem. I cannot
re-assign the serial number because it is tied to other tables.
Anybody had this problem??

I have reached number 14954 which we can't exactly call a high number.

The column description is as follows:

Name   srl
type   bigint
modifiers    default nextval(booking_srl_seq::text)

Any help greatly appreciated.




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

Предыдущее
От: Adam Witney
Дата:
Сообщение: Pattern matching a line ending character... Please ignore previous message, solved!
Следующее
От: Alex
Дата:
Сообщение: Re: Help needed with QueryPlan