| From: | Mike Rylander <mrylander(at)gmail(dot)com> |
|---|---|
| To: | Sam Adams <samadams(at)myfastmail(dot)com>, PostgreSQL SQL <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Serial and Index |
| Date: | 2005-02-27 17:43:23 |
| Message-ID: | b918cf3d0502270943422cc05d@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Sun, 27 Feb 2005 12:54:52 +0000, Sam Adams <samadams(at)myfastmail(dot)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(at)gmail(dot)com
GPLS -- PINES Development
Database Developer
http://open-ils.org
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Don Drake | 2005-02-27 17:55:37 | Re: AutoCommit and DDL |
| Previous Message | Miroslav Šulc | 2005-02-27 17:31:19 | Re: Serial and Index |