diff options
| author | Bruce Momjian <bruce@momjian.us> | 2006-11-22 04:17:03 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2006-11-22 04:17:03 +0000 |
| commit | ba2edcac4fd3c41b58a72f0244ebc0caaeead4af (patch) | |
| tree | 6c49e76c88b2f63ef90d49eaedabbd1778eb2fed /doc/FAQ | |
| parent | 8c556ce1c21c09a8d7f8e0a100cd00fd8faf437c (diff) | |
Mention OIDs are now not created by default.
Diffstat (limited to 'doc/FAQ')
| -rw-r--r-- | doc/FAQ | 12 |
1 files changed, 6 insertions, 6 deletions
@@ -1,7 +1,7 @@ Frequently Asked Questions (FAQ) for PostgreSQL - Last updated: Tue Nov 21 10:37:54 EST 2006 + Last updated: Tue Nov 21 23:16:54 EST 2006 Current maintainer: Bruce Momjian (bruce@momjian.us) @@ -728,11 +728,11 @@ 4.12) What is an OID? What is a CTID? - Every row that is created in PostgreSQL gets a unique OID unless - created WITHOUT OIDS. OIDs are automatically assigned unique 4-byte - integers that are unique across the entire installation. However, they - overflow at 4 billion, and then the OIDs start being duplicated. - PostgreSQL uses OIDs to link its internal system tables together. + If a table is created WITH OIDS, each row gets a unique a OID. OIDs + are automatically assigned unique 4-byte integers that are unique + across the entire installation. However, they overflow at 4 billion, + and then the OIDs start being duplicated. PostgreSQL uses OIDs to link + its internal system tables together. To uniquely number rows in user tables, it is best to use SERIAL rather than OIDs because SERIAL sequences are unique only within a |