Re: Alter Fragment Problems with Serial8

Posted in 2003

Mark D. Stock — Tue, 22 Jul 2003 22:32:38 +0100 — source: Usenet: comp.databases.informix

Brian Foster wrote: > Hi, > > I have a non-fragmented table that contains a serial8 column acting as the > primary-key. When I attempt to consolidate space using 'Alter Fragment > Init' the seed value for the serial8 column is reset and the engine tries to > insert 1 as opposed to max(serial8 column)+1. This does not happen with > serial columns (thank god). Is this a known bug? What do IBM Informix tech support say? Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+ sending to informix-list