diff options
| author | Bruce Momjian <bruce@momjian.us> | 2003-11-19 16:50:48 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2003-11-19 16:50:48 +0000 |
| commit | 022da0ed7af50d532f41da0716d5a4053ddf3ca6 (patch) | |
| tree | 15e0fd2e4b8bdecf45448b966585cf00ae3af56a /doc/src/FAQ | |
| parent | cfeca62148582a05466362f1957572f5a9900ab5 (diff) | |
SERIAL no longer creates an index by default, as of 7.3.
Diffstat (limited to 'doc/src/FAQ')
| -rw-r--r-- | doc/src/FAQ/FAQ.html | 5 |
1 files changed, 2 insertions, 3 deletions
diff --git a/doc/src/FAQ/FAQ.html b/doc/src/FAQ/FAQ.html index 52b11dd0eb5..52a16464909 100644 --- a/doc/src/FAQ/FAQ.html +++ b/doc/src/FAQ/FAQ.html @@ -10,7 +10,7 @@ alink="#0000ff"> <H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1> - <P>Last updated: Sat Nov 15 23:41:03 EST 2003</P> + <P>Last updated: Wed Nov 19 11:50:04 EST 2003</P> <P>Current maintainer: Bruce Momjian (<A href= "mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</A>)<BR> @@ -1102,7 +1102,7 @@ BYTEA bytea variable-length byte array (null-byte safe) serial/auto-incrementing field?</H4> <P>PostgreSQL supports a <SMALL>SERIAL</SMALL> data type. It - auto-creates a sequence and index on the column. For example, + auto-creates a sequence. For example, this:</P> <PRE> CREATE TABLE person ( @@ -1118,7 +1118,6 @@ BYTEA bytea variable-length byte array (null-byte safe) id INT4 NOT NULL DEFAULT nextval('person_id_seq'), name TEXT ); - CREATE UNIQUE INDEX person_id_key ON person ( id ); </PRE> See the <I>create_sequence</I> manual page for more information |