From: | Jesse Kipp <jesse(at)revbox(dot)com> |
---|---|
To: | "Jason C(dot) Wells" <jcwells(at)u(dot)washington(dot)edu>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: [GENERAL] Buggered Sequence |
Date: | 1999-12-04 21:09:36 |
Message-ID: | 38498310.7AE20E1C@revbox.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Can you do:
drop sequence people_id_seq
create sequence people_id_seq start 44
?
jesse kipp
"Jason C. Wells" wrote:
>
> sequence_name|last_value|increment_by| max_value|min_value|cache_value|is_cycled|is_called
> -------------+----------+------------+----------+---------+-----------+---------+---------
> people_id_seq| 4| 1|2147483647| 1| 1|f |t
> (1 row)
>
> After I screwed up a pgdump and restore I finally got my data back into
> the database. I have one little thing to fix. My sequence should be at
> last_value='44'.
>
> I tried to use update set last_value='44' but I wasn't allowed to change
> the sequence as jcwells or as the pgsql superuser. How can I fix my
> sequence?
>
> Thank You, | http://students.washington.edu/jcwells/
> Jason Wells
>
> ************
From | Date | Subject | |
---|---|---|---|
Next Message | Ross J. Reedstrom | 1999-12-04 22:08:48 | Re: [GENERAL] Buggered Sequence |
Previous Message | Jason C. Wells | 1999-12-04 21:02:22 | Buggered Sequence |