Sequence problems during restart

From: "Dave Cramer" <Dave(at)micro-automation(dot)net>
To: "'PostgreSQL'" <pgsql-general(at)postgresql(dot)org>
Subject: Sequence problems during restart
Date: 2001-10-19 17:15:38
Message-ID: 00a001c158c1$acc61680$8201a8c0@inspiron
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We have a number of tables which have unique id's generated from a
sequence

i.e. create table blat (id serial, ....)

A number of these sequences seem to have been "set back" by 4 . In other
words we have records for

Id's 500, 501, 502, 503, and now the sequence is set to 500.

The version of postgres is 7.0.3 running on RH 7.0.

We have recently restarted the databases, and upgraded our glibc.

Has anyone seen anything like this before?

TIA,

Dave

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message BinYang 2001-10-19 17:27:48 Have problem about Perl DBI, Please help
Previous Message Keary Suska 2001-10-19 16:54:34 Authentication FAQ or Howto?