| From: | Terrence Brannon <metaperl(at)mac(dot)com> |
|---|---|
| To: | <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Numbering Rows (SEQUENCE, OID) questions |
| Date: | 2001-12-16 11:56:20 |
| Message-ID: | EBA7F074-F21B-11D5-92F7-003065C2A10C@mac.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice 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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2001-12-16 19:42:41 | Re: Numbering Rows (SEQUENCE, OID) questions |
| Previous Message | Josh Berkus | 2001-12-15 22:14:23 | Re: Import DB from DOS- dbase4 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Terrence Brannon | 2001-12-16 19:39:14 | What happens if you delete a row containing a BLOB? |
| Previous Message | Marc Spitzer | 2001-12-16 02:25:51 | Re: should this be a trigger or a rule? |