Re: Serial Datatypes

No, it shouldn't. To do that would require a lock on the serial type part, preventing anybody else from inserting into the table while the first transaction is in progress. The behaviour always has been as it is. SERIAL is not standardized, so there is no appeal to a standard other than the de facto one -- it is implemented as it is. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> }From informix-list-owner@rmy.emory.edu Tue Jun 25 18:51 PDT 1996 }From: Vikram <vlulla@systems.dhl.com> }Subject: Serial Datatypes }Date: Tue, 25 Jun 1996 21:03:42 GMT }To: informix-list@rmy.emory.edu }X-Informix-List-To: johnl@informix.com }X-Informix-List-Id: <news.25429> } }To all : } }I am trying to insert rows into three tables A, B & C in one }transaction. } }Table A contains a serial field. (Say the last row inserted has a value }100 in this field) } }Now if for some reason a transaction is rolled back, the serial field }also should be rolled back. } }But when I try to insert the next transaction successfully, the serial }field contains 102 and not 101. } }Is this a bug or what ?? } }I am using Informix on-line version 5.03.UC5 on HP-UX 9.05 } }Any suggestions will be appreciated. } }Thanks. }