Date: Wed, 3 Jan 2001 16:04:36 +0800
From: anson <anson@gigaideas.com.cn>
Reply-To: anson <anson@gigaideas.com.cn>
Message-ID: <5669.010103@gigaideas.com.cn>
To: pgsql-docs@postgresql.org
Subject: Sequence
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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