Received: from bastuba.partitur.se (bastuba.partitur.se [193.219.246.194]) by hub.org (8.9.2/8.9.1) with ESMTP id IAA12595 for ; Tue, 16 Mar 1999 08:22:25 -0500 (EST) (envelope-from kudo@partitur.se) Received: from partitur.se (tb303.partitur.se [193.219.246.230]) by bastuba.partitur.se (8.8.8/8.8.8) with ESMTP id OAA28655; Tue, 16 Mar 1999 14:22:04 +0100 (CET) (envelope-from kudo@partitur.se) Sender: kudo@partitur.se Message-ID: <36EE5AFB.E9F2771D@partitur.se> Date: Tue, 16 Mar 1999 14:22:03 +0100 From: Patrik Kudo Organization: Partitur Informationsteknik X-Mailer: Mozilla 4.51 [en] (X11; I; FreeBSD 3.1-STABLE i386) X-Accept-Language: sv,en MIME-Version: 1.0 To: Tim Perdue CC: pgsql-sql@hub.org Subject: Re: [SQL] Setting Next Value in Sequence References: <009801be6fa9$c8c0d770$0b8c5aa5@timnt.weather.net> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi, You can't manipulate the sequence that way. You can do the following though: select setval('seq_mailid', 1375000); Hope that helps. Regards, Patrik Kudo 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. > > Tim