Changeing Sequence - Mailing list pgsql-sql

From Peter Atkins
Subject Changeing Sequence
Date
Msg-id 02E689F991FFD311A75D009027B6A73E0886EAB1@corp_mail01.sf.nextcard.com
Whole thread Raw
Responses Re: Changeing Sequence
Re: Changeing Sequence
List pgsql-sql
All,

I have a table "mytable_id_seq" that looks like so.
   sequence_name     | last_value | increment_by |      max_value      |
min_value | cache_value | log_cnt | is_cycled | is_called
----------------------+------------+--------------+---------------------+---
--------+-------------+---------+-----------+-----------mytqble_id_seq |          4 |            1 |
9223372036854775807|
 
1 |           1 |      30 | f         | t


I have data that must be entered into the table "mytable" with pre-defined
ids (i.e. 1,3,5,7,25). Is it possible to change the sequence to start at
"26" the last value of the previous data?

Please tell me YES! I get an error: "ERROR:  You can't change sequence
relation t_staff_staff_id_seq"

Any Help would be great!

Thanks,
-pete


pgsql-sql by date:

Previous
From: "John Oakes"
Date:
Subject: Possible to do this in one query?
Next
From: Stephan Szabo
Date:
Subject: Re: Changeing Sequence