Numbering Rows (SEQUENCE, OID) questions - Mailing list pgsql-sql

From Terrence Brannon
Subject Numbering Rows (SEQUENCE, OID) questions
Date
Msg-id EBA7F074-F21B-11D5-92F7-003065C2A10C@mac.com
Whole thread Raw
In response to how does one replace a row in Postgresql? (ala MySQL REPLACE)  (Terrence Brannon <metaperl@mac.com>)
Responses Re: Numbering Rows (SEQUENCE, OID) questions
List pgsql-sql
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?



pgsql-sql by date:

Previous
From: Marc Spitzer
Date:
Subject: Re: should this be a trigger or a rule?
Next
From: Stephan Szabo
Date:
Subject: Re: Numbering Rows (SEQUENCE, OID) questions