Re: Informix memory errors, 'serial' number errors

Felipe Barousse writes: Sorry, can't help on the memory problem. Aland knows more about SCO that I by far, perhaps he will interject a few thoughts. |> On other issues, has any of you experienced problems with the 'serial' data |> type on Informix. It seems to us that the supposed 'serial', never repeating; |> incremental numbers are not working properly, they DO repeat. Has this |> happened to someone else ? Please tell your story and how you solved it. |> The configuration is the same described above. Yes, serials can repeat. You can roll over a serial value and start over. If you supply a non-zero value rather than inserting a 0 in a serial field, it will use the value you provide. Uniqueness is not inherently garanteed - you must add a unique index onto the serial column for that. Perhaps if you provide some detail on just what behavior you are experiencing with serial columns, we can provide some explanation. Dave