Re: Sequence problems during restart

On Fri, 19 Oct 2001 13:15:38 -0400
"Dave Cramer" wrote:

> 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.
>

Hi,

How about using a CREATE SEQUENCE with a CYCLE option.

e.g.
create sequence seq_blat minvalue 500 maxvalue 503 cycle;
create table blat (id int4 default nextval('seq_blat'),
a varchar(10),
b varchar(10),
......
);

insert into blat (a, b, ...) values('aaa1', 'bbb1', .... );
insert into blat (a, b, ...) values('aaa2', 'bbb2', .... );
insert into blat (a, b, ...) values('aaa3', 'bbb3', .... );
...

By the way, a mail server has been downed ?

Regards,
Masaru Sugawara