Re: serial field approaching limit

From: austin castro <acastro@bel.com.bz> > > A collegue of mine is having the following problem: > > The highest number that can be assigned to a serial datatype in >Informix7.24 is 2147483647. He has a table that is frequently updated with >both adds and deletes. As items are added, the serial datatype is >approaching this maximum number. There are many gaps in between that could >be recycled and he needs to find a way to do this. The only option he can >find is to reload the table, but this would cause problems with other >tables >that use this serial column as a foreign key. > >Is there any way to recycle old numbers in a serial datatype column? No. Unless you manually work out which one's you can reuse and inserting them manually. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com