Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id D43E49FB9C8 for ; Tue, 3 Apr 2007 12:27:00 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 96838-02 for ; Tue, 3 Apr 2007 12:26:54 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from web31803.mail.mud.yahoo.com (web31803.mail.mud.yahoo.com [68.142.207.66]) by postgresql.org (Postfix) with SMTP id 2B1DA9FBFFF for ; Tue, 3 Apr 2007 12:24:52 -0300 (ADT) Received: (qmail 82631 invoked by uid 60001); 3 Apr 2007 15:24:42 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=1poZ+hXydznxsB0Dm5fSPlpZlpiCrwGKXDED/i/xe4XA35F1J7JNBsxgffQyn7SonpH6iJyYeRgazO505L/ySfJVaLQS+3rgIt3POpWvd7zwxsEY/p9JVMlvDJOKmhYYeazLAabnAqEfuZ/UkPkjg9qZ7F/J0M3U2aFgZKj3+oM=; X-YMail-OSG: jSvbERMVM1mdDvk7DNDbngoUyC4DkU5QlDJOOLk64vTRXyhM3NSPidM8dJ8wApNpLw35YxaxwGuVg6DdX1Qmw_BbthvGcqRmn.wSYMU1WWti0kqwDnA- Received: from [63.203.180.122] by web31803.mail.mud.yahoo.com via HTTP; Tue, 03 Apr 2007 08:24:42 PDT Date: Tue, 3 Apr 2007 08:24:42 -0700 (PDT) From: Richard Broersma Jr Subject: Re: Serial To: Scott Marlowe , Shavonne Marietta Wijesinghe Cc: pgsql-sql@postgresql.org In-Reply-To: <1175609839.22459.3.camel@state.g2switchworks.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <407615.82627.qm@web31803.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.697 tagged_above=0 required=5 tests=AWL=-0.918, BAYES_20=-0.74, DNS_FROM_RFC_ABUSE=0.2, DNS_FROM_RFC_POST=1.708, DNS_FROM_RFC_WHOIS=1.447 X-Spam-Level: * X-Archive-Number: 200704/34 X-Sequence-Number: 28034 --- > Yes there is, and you generally shouldn't do it. There are issues with > race conditions and misreferenced data that can happen when you try to > reuse sequence numbers. > > Sadly, some poorly defined business processes require this. > > Are you required to have sequential numbers, or is just something that > feels good / looks good? The following link develops the use of a gapless sequence: http://www.varlena.com/GeneralBits/130.php Regards, Richard Broersma Jr.