X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 685C4474E4F for ; Fri, 21 Feb 2003 01:29:33 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 29363-04 for ; Fri, 21 Feb 2003 01:29:22 -0500 (EST) Received: from web14204.mail.yahoo.com (web14204.mail.yahoo.com [216.136.172.146]) by postgresql.org (Postfix) with SMTP id 85F90474E61 for ; Fri, 21 Feb 2003 01:29:22 -0500 (EST) Message-ID: <20030221062922.30510.qmail@web14204.mail.yahoo.com> Received: from [203.125.237.38] by web14204.mail.yahoo.com via HTTP; Thu, 20 Feb 2003 22:29:22 PST Date: Thu, 20 Feb 2003 22:29:22 -0800 (PST) From: Raymond Pau Subject: Re: How to make sequence skip existing key in table? To: pgsql-sql@postgresql.org In-Reply-To: <200302180907.21014.josh@agliodbs.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/471 X-Sequence-Number: 11869 --- Josh Berkus wrote: > Raymond, > > > I am using sequence to generate to a list of > unique > > key id that will be used as the primary key for > some > > tables. > > > > My question is when the sequence wraps over to the > > minimum value(1), how can I ensure that the next > id is > > not in the tables? > > Do you really expect more than 2.4 billion rows? No, not really. I guess my worries are groundless after all. Thanks. > > -- > Josh Berkus > Aglio Database Solutions > San Francisco __________________________________________________ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/