Buggered Sequence - Mailing list pgsql-general

From Jason C. Wells
Subject Buggered Sequence
Date
Msg-id Pine.BSF.4.10.9912042058320.63812-100000@s8-37-26.student.washington.edu
Whole thread Raw
List 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


pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [GENERAL] postgres libpq library
Next
From: Jesse Kipp
Date:
Subject: Re: [GENERAL] Buggered Sequence