Received: from scaup.prod.itd.earthlink.net (scaup.mail.pas.earthlink.net [207.217.120.49]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fBGGCJm18288 for ; Sun, 16 Dec 2001 11:12:19 -0500 (EST) (envelope-from metaperl@mac.com) Received: from pool0213.cvx7-bradley.dialup.earthlink.net ([209.178.164.213] helo=localhost) by scaup.prod.itd.earthlink.net with esmtp (Exim 3.33 #1) id 16Fdtn-0007T8-00 for pgsql-sql@postgresql.org; Sun, 16 Dec 2001 08:12:23 -0800 Date: Sun, 16 Dec 2001 03:56:20 -0800 Subject: Numbering Rows (SEQUENCE, OID) questions Content-Type: text/plain; charset=US-ASCII; format=flowed Mime-Version: 1.0 (Apple Message framework v475) From: Terrence Brannon To: Content-Transfer-Encoding: 7bit In-Reply-To: Message-Id: X-Mailer: Apple Mail (2.475) X-Archive-Number: 200112/161 X-Sequence-Number: 5984 The Momjian book is excellent (in spite of some of the bonehead reviews on amazon.com). I just finished the "Numbering Rows" section and have a few questions. None of these were in the FAQ, BTW. 1 - are OIDs ever re-used if rows are deleted? 2 - for both SEQUENCE and OID, when might we expect them to rollover? Ie, what is the largest integer we can use for either of these? 3 - What does one do once the rollover limit is reached if one wants to continue to add new row numbers?