Re: Serial and Index - Mailing list pgsql-sql

From Mike Rylander
Subject Re: Serial and Index
Date
Msg-id b918cf3d0502270943422cc05d@mail.gmail.com
Whole thread Raw
In response to Serial and Index  ("Sam Adams" <samadams@myfastmail.com>)
List pgsql-sql
On Sun, 27 Feb 2005 12:54:52 +0000, Sam Adams <samadams@myfastmail.com> wrote:
> I read at http://jamesthornton.com/postgres/FAQ/faq-english.html#4.15.1
> that when a serial is created then an index is created on the column.
> However I can't seem to find this anywhere in the PoistgreSQL manual. Is
> this true? Thanks.

The FAQ entry is incorrect.  If you make your SERIAL column the
PRIMARY KEY of the table, however, a UNIQUE index will be created.

-- 
Mike Rylander
mrylander@gmail.com
GPLS -- PINES Development
Database Developer
http://open-ils.org


pgsql-sql by date:

Previous
From: Don Drake
Date:
Subject: Re: AutoCommit and DDL
Next
From: Miroslav Šulc
Date:
Subject: Re: Serial and Index