The information I ported from another database contained unique ID's that are referenced by other dependant tables.
The data was ported without SERIAL defined. Then I did an alter table which allowed SERIAL as default since there was no id's 1 to 12, but then it gave the duplicate error in insert for 13 (an existing record). Some holes in the serial numbers also exist further on in the table, due to the increment method previously used in the ISAM format. It was using a sequencing system which autoincremented with a record being created on insert as the user captures the record and then literally updated after the records contents was provided (when the user clicked the OK button.). This method is getting slow on this particular table as it grows. And always leads to gaps in the sequence numbers. Can anyone please suggest a method to implement SERIAL afterwards as described here? Can I force a next value for the SERIAL value on this existing table? Regards Marius Snyman --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.293 / Virus Database: 158 - Release Date: 2001/10/29
