From: anson <anson@gigaideas.com.cn>
To: pgsql-docs@postgresql.org
Subject: Sequence
Date: Wed, 3 Jan 2001 16:04:36 +0800
Message-ID: <5669.010103@gigaideas.com.cn> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: anson@gigaideas.com.cn
Subject: Re: Sequence
In-Reply-To: <5669.010103@gigaideas.com.cn>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox