Sync serial value after manually inserted records

Hi all,

I've encountered a very serious problem using serials.

A MaxDB is first filled via an ETL-process as a copy of a different DBMS,  
i.e. all tables containing serial columns are filled not by the MaxDB  
number generator, but by a manual insert.

The source database is already used and, because of some normal deletions,  
the serial ids are not subsequent.

Using the new filled MaxDB our application gets lots of "Duplicate key  
error", because the next generated serial id is already in use within the  
table.

So here are the questions:

+) Is it possible to synchronize the max value of a serial with the  
highest value of the serial id within the table?

+) Is there any way, maybe as dba, to change the current serial value  
within the cataloge?

+) Is there any other way to use serials for tables wich values can also  
be manually inserted?

Environment is
- Linux / WindowsXP SP2
- MaxDB version: 7.5.00.18 build 018-121-079-776
- JDBC-driver-version: 7.6.0   build 000-000-003-264

Different combinations of other (newer/older) versions are also tested  
without success.

Any help is greatly appreciate.

--
Erik Rehrmann

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx