Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 105E79FB409 for ; Fri, 3 Aug 2007 17:33:39 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 29849-07 for ; Fri, 3 Aug 2007 17:33:35 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mtao03.charter.net (mtao03.charter.net [209.225.8.188]) by postgresql.org (Postfix) with ESMTP id AEF2B9FA5FA for ; Fri, 3 Aug 2007 17:33:35 -0300 (ADT) Received: from aa04.charter.net ([10.20.200.156]) by mtao03.charter.net (InterMail vM.7.08.02.02 201-2186-121-104-20070414) with ESMTP id <20070803203330.QZFD15538.mtao03.charter.net@aa04.charter.net>; Fri, 3 Aug 2007 16:33:30 -0400 Received: from [10.0.1.3] (really [66.188.165.91]) by aa04.charter.net with ESMTP id <20070803203330.WEUU1254.aa04.charter.net@[10.0.1.3]>; Fri, 3 Aug 2007 16:33:30 -0400 In-Reply-To: References: <20070803165058.020509FBF2F@postgresql.org> Mime-Version: 1.0 (Apple Message framework v752.2) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <6137A8C5-187D-46E8-B9C2-822D05C5DFC2@seespotcode.net> Cc: Steve Midgley , pgsql-sql@postgresql.org Content-Transfer-Encoding: 7bit From: Michael Glaesemann Subject: Re: Increment a sequence by more than one Date: Fri, 3 Aug 2007 15:33:28 -0500 To: Erik Jones X-Mailer: Apple Mail (2.752.2) X-Chzlrs: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/28 X-Sequence-Number: 28966 On Aug 3, 2007, at 15:27 , Erik Jones wrote: > Is there actually a requirement that the block of 5000 values not > have gaps? Good point. > If not, why not make the versioned table's id column default to > nextval from the same sequence? Of course, the ids of the two tables could be interleaved in this case. This might not be an issue, of course. Michael Glaesemann grzm seespotcode net