> 1. Do the transfer, put values into the serial field, then find the
> highest value and manually set the sequence somehow to start from
> highest+1 (seed value). (I understand there is a problem with orphan
> sequences with serial fields if you drop tables, so maybe I shouldn't
> use serials anyway?)
I'd suggest to use this sollution. I have had the same problem some time
ago and solved it by inserting my tables and then creating the erial.
Cheers
Jochen