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 | |
| parent | cfeca62148582a05466362f1957572f5a9900ab5 (diff) | |
| download | postgresql-022da0ed7af50d532f41da0716d5a4053ddf3ca6.tar.gz postgresql-022da0ed7af50d532f41da0716d5a4053ddf3ca6.zip | |
SERIAL no longer creates an index by default, as of 7.3.
| -rw-r--r-- | doc/FAQ | 7 | ||||
| -rw-r--r-- | doc/src/FAQ/FAQ.html | 5 |
2 files changed, 5 insertions, 7 deletions
@@ -1,7 +1,7 @@ Frequently Asked Questions (FAQ) for PostgreSQL - Last updated: Sat Nov 15 23:41:03 EST 2003 + Last updated: Wed Nov 19 11:50:04 EST 2003 Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) @@ -879,8 +879,8 @@ BYTEA bytea variable-length byte array (null-byte safe) 4.15.1) How do I create a serial/auto-incrementing field? - PostgreSQL supports a SERIAL data type. It auto-creates a sequence and - index on the column. For example, this: + PostgreSQL supports a SERIAL data type. It auto-creates a sequence. + For example, this: CREATE TABLE person ( id SERIAL, name TEXT @@ -892,7 +892,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 ); See the create_sequence manual page for more information about sequences. You can also use each row's OID field as a unique value. 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 |