Received: from mx99.openu.ac.il (arbel.openu.ac.il [147.233.32.4]) by hub.org (8.9.2/8.9.1) with ESMTP id IAA12627 for ; Tue, 16 Mar 1999 08:22:48 -0500 (EST) (envelope-from herouth@oumail.openu.ac.il) Received: from talmon.openu.ac.il (talmon.openu.ac.il [147.233.32.11]) by mx99.openu.ac.il (Postfix) with ESMTP for id A85F94B4A0; Tue, 16 Mar 1999 15:22:46 +0200 (IST) Received: from [147.233.159.109] (mac-herouth.pc.openu.ac.il) by talmon.openu.ac.il (Netscape Messaging Server 3.54) with ESMTP id AAA1D21; Tue, 16 Mar 1999 15:24:22 +0200 X-Sender: herouth@shaked.cc.openu.ac.il Message-Id: In-Reply-To: <00ad01be6fad$c1097380$0b8c5aa5@timnt.weather.net> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Date: Tue, 16 Mar 1999 15:23:52 +0200 To: "Tim Perdue" , From: Herouth Maoz Subject: Re: [SQL] Setting Next Value in Sequence At 15:06 +0200 on 16/3/99, Tim Perdue wrote: > May table is defined to use the sequence, and the table is not trivial to > export and rebuild with the new sequence. > > There's got to be some way around this. I'm probably going to have to create > a bogus table using that sequence, then insert 150,000 bogus records to > increment the sequence. Then drop the table. What? You just need to drop and create a sequence with the same name. At least it works for me (though I noticed that unprivileged users have problems creating tables without having the sequences created first, which IMHO is a bug. But I don't think it applies to already-created tables). Herouth -- Herouth Maoz, Internet developer. Open University of Israel - Telem project http://telem.openu.ac.il/~herutma