----- Original Message -----
From: Kancha . <kancha2np@yahoo.com>
To: <pgsql-general@postgresql.org>; <pgsql-sql@postgresql.org>
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;