| From: | "Jason C(dot) Wells" <jcwells(at)u(dot)washington(dot)edu> |
|---|---|
| To: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Buggered Sequence |
| Date: | 1999-12-04 21:02:22 |
| Message-ID: | Pine.BSF.4.10.9912042058320.63812-100000@s8-37-26.student.washington.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 | Jesse Kipp | 1999-12-04 21:09:36 | Re: [GENERAL] Buggered Sequence |
| Previous Message | Peter Eisentraut | 1999-12-04 02:24:03 | Re: [GENERAL] postgres libpq library |