Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitba2edca

Browse files
committed
Mention OIDs are now not created by default.
1 parent8c556ce commitba2edca

File tree

2 files changed

+14
-14
lines changed

2 files changed

+14
-14
lines changed

‎doc/FAQ

Lines changed: 6 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -1,7 +1,7 @@
11

22
Frequently Asked Questions (FAQ) for PostgreSQL
33

4-
Last updated: Tue Nov 2110:37:54 EST 2006
4+
Last updated: Tue Nov 2123:16:54 EST 2006
55

66
Current maintainer: Bruce Momjian (bruce@momjian.us)
77

@@ -728,11 +728,11 @@
728728

729729
4.12) What is an OID? What is a CTID?
730730

731-
Every row that is createdin PostgreSQLgets a unique OID unless
732-
created WITHOUT OIDS. OIDsare automatically assigned unique 4-byte
733-
integers that are uniqueacross the entire installation. However, they
734-
overflow at 4 billion,and then the OIDs start being duplicated.
735-
PostgreSQL uses OIDs to linkits internal system tables together.
731+
If a table is createdWITH OIDS, each rowgets a uniqueaOID. OIDs
732+
are automatically assigned unique 4-byte integers that are unique
733+
across the entire installation. However, they overflow at 4 billion,
734+
and then the OIDs start being duplicated. PostgreSQL uses OIDs to link
735+
its internal system tables together.
736736

737737
To uniquely number rows in user tables, it is best to use SERIAL
738738
rather than OIDs because SERIAL sequences are unique only within a

‎doc/src/FAQ/FAQ.html

Lines changed: 8 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -10,7 +10,7 @@
1010
alink="#0000ff">
1111
<H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1>
1212

13-
<P>Last updated: Tue Nov 2110:37:54 EST 2006</P>
13+
<P>Last updated: Tue Nov 2123:16:54 EST 2006</P>
1414

1515
<P>Current maintainer: Bruce Momjian (<Ahref=
1616
"mailto:bruce@momjian.us">bruce@momjian.us</A>)
@@ -956,13 +956,13 @@ <H3 id="item4.11.4">4.11.4) Why aren't my sequence numbers
956956
<H3id="item4.12">4.12) What is an<SMALL>OID</SMALL>? What is
957957
a<SMALL>CTID</SMALL>?</H3>
958958

959-
<P>Every row that is createdin PostgreSQL gets a unique
960-
<SMALL>OID</SMALL> unless created<SMALL>WITHOUT OIDS</SMALL>.
961-
O<SMALL>ID</SMALL>s areautomatically assigned unique 4-byte
962-
integers that are uniqueacross the entire installation. However,
963-
they overflow at 4billion, and then the O<SMALL>ID</SMALL>s start
964-
being duplicated.PostgreSQL uses<SMALL>OID</SMALL>s to link its
965-
internal systemtables together.</P>
959+
<P>If a table is created<SMALL>WITH OIDS</SMALL>, each row
960+
gets a unique a<SMALL>OID</SMALL>. O<SMALL>ID</SMALL>s are
961+
automatically assigned unique 4-byte integers that are unique
962+
across the entire installation. However, they overflow at 4
963+
billion, and then the O<SMALL>ID</SMALL>s start being duplicated.
964+
PostgreSQL uses<SMALL>OID</SMALL>s to link its internal system
965+
tables together.</P>
966966

967967
<P>To uniquely number rows in user tables, it is best to use
968968
<SMALL>SERIAL</SMALL> rather than O<SMALL>ID</SMALL>s because

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp