Home > mailing lists

Re: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index - Mailing list pgsql-sql

From	Ludwig Lim
Subject	Re: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
Date	January 22, 2003 04:53:12
Msg-id	20030122095311.49903.qmail@web80313.mail.yahoo.com Whole thread Raw
In response to	NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index ("David Durst" <ddurst@larubber.com>)
List	pgsql-sql

Tree view

--- David Durst <ddurst@larubber.com> wrote:
> Can anyone tell me why postgres is creating a
> implicit index when
> I already have a PKEY specified????
> 
> Or am I just interpreting this all wrong?
 PostgreSQL uses UNIQUE INDEX to enforce PRIMARY KEY
constraint. Therefore creating a PRIMARY KEY will
automatically create a UNIQUE INDEX.

ludwig.


__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com

pgsql-sql by date:

From: Achilleus Mantzios
Date: 22 January 2003, 04:42:35
Subject: Re: optimal sql

From: "Michael Paesold"
Date: 22 January 2003, 05:02:33
Subject: Re: optimal sql

Re: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index - Mailing list pgsql-sql

Previous

Next