Received: from xyzzy.lan.internal (cvx-west-206-47-80-67.kingston.net [206.47.80.67]) by postgresql.org (Postfix) with ESMTP id D00A4475D29; Wed, 27 Mar 2002 10:07:01 -0500 (EST) Received: from drew by xyzzy.lan.internal with local (Exim 3.35 #1 (Debian)) id 16qF0u-000241-00; Wed, 27 Mar 2002 10:07:00 -0500 Date: Wed, 27 Mar 2002 10:07:00 -0500 To: Philip Hallstrom Cc: "Kancha ." , pgsql-general@postgresql.org, pgsql-sql@postgresql.org Subject: Re: [SQL] resetting sequence Message-ID: <20020327150700.GB7777@xyzzy.dhs.org> References: <20020327023039.13665.qmail@web14914.mail.yahoo.com> <20020326212937.K37166-100000@teak.adhesivemedia.com> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="lEGEL1/lMxI0MVQ2" Content-Disposition: inline In-Reply-To: <20020326212937.K37166-100000@teak.adhesivemedia.com> User-Agent: Mutt/1.3.27i From: "Andrew G. Hammond" X-Fnord: +++ath X-WebTV-Stationery: Standard; BGColor=black; TextColor=black X-Message-Flag: Message text blocked: ANTI-MICROSOFT OPINIONS X-BeenThere: drew@xyzzy.dhs.org X-Archive-Number: 200203/1281 X-Sequence-Number: 22639 --lEGEL1/lMxI0MVQ2 Content-Type: text/plain; charset=unknown-8bit Content-Disposition: inline Content-Transfer-Encoding: quoted-printable It also looks like you might want to check out the unix cron utility.=20=20 =46rom your shell prompt, try=20 man crontab On Tue, Mar 26, 2002 at 09:30:10PM -0800, Philip Hallstrom wrote: > take a look at the SETVAL function... it's something close to: >=20 > SELECT SETVAL('sequence_name', 1); >=20 > something like that. check the manual. >=20 > On Tue, 26 Mar 2002, Kancha . wrote: >=20 > > My sequence starts from 1 and after few months it > > should be reset to 1 again. Can this be automated ?? > > > > __________________________________________________ > > Do You Yahoo!? > > Yahoo! Movies - coverage of the 74th Academy Awards=AE > > http://movies.yahoo.com/ > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 5: Have you checked our extensive FAQ? > > > > http://www.postgresql.org/users-lounge/docs/faq.html > > >=20 >=20 > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) --=20 Andrew G. Hammond mailto:drew@xyzzy.dhs.org http://xyzzy.dhs.org/~drew/ 56 2A 54 EF 19 C0 3B 43 72 69 5B E3 69 5B A1 1F 613-389-5481= =20 5CD3 62B0 254B DEB1 86E0 8959 093E F70A B457 84B1 "To blow recursion you must first blow recur" -- me --lEGEL1/lMxI0MVQ2 Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iEYEARECAAYFAjyh4BQACgkQCT73CrRXhLFCBgCfTdejlg7BX6g/ZFlP4TWED7BI 1zEAnjYojvhDFgrNM/FmseP3+1oa3JwJ =g9HG -----END PGP SIGNATURE----- --lEGEL1/lMxI0MVQ2--