Re: Sequence problems during restart
От | Dave Cramer |
---|---|
Тема | Re: Sequence problems during restart |
Дата | |
Msg-id | 017801c15b2b$9d80a660$8201a8c0@inspiron обсуждение исходный текст |
Ответ на | Re: Sequence problems during restart (Masaru Sugawara <rk73@echna.ne.jp>) |
Ответы |
Re: Sequence problems during restart
|
Список | pgsql-general |
How does this fix my problem? It appears like the sequence was generated properly, but possible not written to disk at shutdown time. There is some additional information here. We did an upgrade of glibc just before the restart Dave -----Original Message----- From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Masaru Sugawara Sent: October 22, 2001 11:34 AM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] 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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly
В списке pgsql-general по дате отправления: