Sequence
От | anson |
---|---|
Тема | Sequence |
Дата | |
Msg-id | 5669.010103@gigaideas.com.cn обсуждение исходный текст |
Ответы |
Re: Sequence
|
Список | pgsql-docs |
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
В списке pgsql-docs по дате отправления: