Serial column has suddenly stopped working

From: Malcolm Warren <malcolm(at)villeinitalia(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Serial column has suddenly stopped working
Date: 2004-12-16 12:12:56
Message-ID: 41C17BC8.6060300@villeinitalia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Ben-Nes 2004-12-16 12:39:26 Re: What HW / OS is recommeded
Previous Message Adam Witney 2004-12-16 11:44:38 Pattern matching a line ending character... Please ignore previous message, solved!