Received: from mailmtx.acnet.net (mailmtx.acnet.net [170.76.16.130]) by postgresql.org (Postfix) with ESMTP id 1E99947586C; Wed, 27 Mar 2002 02:08:04 -0500 (EST) Received: from automaton ([170.76.42.163]) by mailmtx.acnet.net (Post.Office MTA v3.5.3 release 223 ID# 0-52476U50000L50000S0V35) with SMTP id net; Wed, 27 Mar 2002 01:06:14 -0600 Message-ID: <001201c1d55d$f14b4000$0108a8c0@automaton> From: "David Stanaway" To: , References: <20020327023039.13665.qmail@web14914.mail.yahoo.com> Subject: Re: [SQL] resetting sequence Date: Wed, 27 Mar 2002 01:06:37 -0600 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 X-Archive-Number: 200204/74 X-Sequence-Number: 22797 ----- Original Message ----- From: Kancha . To: ; Sent: Tuesday, March 26, 2002 8:30 PM Subject: [SQL] resetting sequence > My sequence starts from 1 and after few months it > should be reset to 1 again. Can this be automated ?? If the use of the sequence is predictable, you may want to alter the CYCLE and MAXVALUE options in the seqence creation. EG: CREATE SEQUENCE foo MAXVALUE 3000 CYCLE;