Sequence problems during restart - Mailing list pgsql-general

From Dave Cramer
Subject Sequence problems during restart
Date
Msg-id 00a001c158c1$acc61680$8201a8c0@inspiron
Whole thread Raw
In response to Re: Possible bug in postgresql-7.1.3-1PGDG  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: Sequence problems during restart  (Masaru Sugawara <rk73@echna.ne.jp>)
List 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


pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Possible bug in postgresql-7.1.3-1PGDG
Next
From: Linh Luong
Date:
Subject: DEBUG: StartTransactionCommand