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.
Tim
-----Original Message-----
From: Remigiusz Sokolowski <rems@gdansk.sprint.pl>
To: Tim Perdue <perdue@raccoon.com>
Cc: pgsql-sql@hub.org <pgsql-sql@hub.org>
Date: Tuesday, March 16, 1999 6:57 AM
Subject: Re: [SQL] Setting Next Value in Sequence
>> 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.
>
>So, may be just drop sequence and create new one with start 1375000.
> Rem
>
>-------------------------------------------------------------------*-------
-----
>Remigiusz Sokolowski e-mail: rems@gdansk.sprint.pl * *
>-----------------------------------------------------------------*****-----
-----
