Sequence

Поиск
Список
Период
Сортировка
От anson
Тема Sequence
Дата
Msg-id 5669.010103@gigaideas.com.cn
обсуждение исходный текст
Ответы Re: Sequence  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Gilles Bernard"
Дата:
Сообщение: Re: Postgres ignoring RTree for geometric operators
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Postgres ignoring RTree for geometric operators