Re: SERIAL data type

Enda Finnan (finnan@sse.ie) wrote: : Does anyone if their is a mechanism or workaround to get the SERIAL datatype : to wrap back to 1 (or some other value) when it reaches its maximum (2147483647) : I'm working with Informix 5.0 and will be moving to 6.0 and 7.0 In my OnLine 5.02 it wraps back from 2^31-1 to 1 automatically. However, you can have problems when inserting new rows into such table. (when counter reaches existing rows). Mariusz -- ------------------------------------------------------------- Mariusz Ostrowski mariusz@nask.org.pl Research and Academic Computer Networks Warsaw, Poland -------------------------------------------------------------