From 022da0ed7af50d532f41da0716d5a4053ddf3ca6 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Wed, 19 Nov 2003 16:50:48 +0000 Subject: SERIAL no longer creates an index by default, as of 7.3. --- doc/src/FAQ/FAQ.html | 5 ++--- 1 file changed, 2 insertions(+), 3 deletions(-) (limited to 'doc/src/FAQ/FAQ.html') 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">

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)
@@ -1102,7 +1102,7 @@ BYTEA bytea variable-length byte array (null-byte safe) serial/auto-incrementing field?

PostgreSQL supports a SERIAL data type. It - auto-creates a sequence and index on the column. For example, + auto-creates a sequence. For example, this:

     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 );
 
See the create_sequence manual page for more information -- cgit v1.2.3