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 IAA09967 for ; Tue, 16 Mar 1999 08:02:36 -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 4892E4B49F; Tue, 16 Mar 1999 15:02:35 +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 AAA17AC; Tue, 16 Mar 1999 15:04:14 +0200 X-Sender: herouth@shaked.cc.openu.ac.il Message-Id: In-Reply-To: <009801be6fa9$c8c0d770$0b8c5aa5@timnt.weather.net> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Date: Tue, 16 Mar 1999 15:03:44 +0200 To: "Tim Perdue" , From: Herouth Maoz Subject: Re: [SQL] Setting Next Value in Sequence At 14:37 +0200 on 16/3/99, Tim Perdue wrote: > Maybe it's due to sleep deprivation, but this is not working. I'm trying to > update a seqence to a higher number, and it won't let me. > > db_domain=> update seq_mailid set last_value=1375000; > ERROR: You can't change sequence relation seq_mailid > > My sense of humor has totally faded over the last two days, and I would > appreciate sone input. Do you (or the user who is trying to do this) own the sequence? Do you have the right access rights to it? In any case, I always thought the best is to drop the sequence and create it with a proper start number. Herouth -- Herouth Maoz, Internet developer. Open University of Israel - Telem project http://telem.openu.ac.il/~herutma