Hi,
I've got the following problem:
I want to replicate my database and I tried to do this with with the
Loader (loadercli).
So I use catalogextract/tableextract to unload the database. When I use
catalogload/tableload to import the database, all the tables are created
and data is imported. But the sequences for the SERIAL-Columns which I
use for primary keys are reset to 1. So when I start adding records, the
value for the primary key is not max(last inserted serial) but 1.
Therefore I always get errors ("Integrity constraint violation;200
POS(1) Duplicate key").
I would try to recalculate and set the serials myself, but it is not
possible to issue MODIFY-statements with DEFAULT SERIAL like ALTER TABLE
tab MODIFY (tab_id DEFAULT SERIAL(342)).
Is there a solution to this problem?
Thanks for your help,
Bettina
E-Mail: [EMAIL PROTECTED]
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
