Sequence

Started by ansonover 25 years ago2 messagesdocs
Jump to latest
#1anson
anson@gigaideas.com.cn

Hello,
i have some problem with the Sequence of pgsql.
for example:
i have made a talbe named tbl_a and his sequence named
tbl_a_log_id_seq, then i insert into tbl_a with amounts of
records, so the last value of tbl_a_log_id_seq become 200.
someday, i get this table move to a new machine, create a new
table, a new sequence, so there becomes the problem!
i cann't insert a new record into tbl_a when there are old records
in the table, because the log_id has become from 1 to 200, but the
last_value of tbl_a_log_id_seq is 1!!!!!and i even can't change
the value of last_value, how can i do now? i don't wanna lose the
old records!
please help me!

--
Best regards,
anson mailto:anson@gigaideas.com.cn

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: anson (#1)
Re: Sequence

Do
SELECT setval('tbl_a_log_id_seq', 201);

regards, tom lane