Re: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index

From: Ludwig Lim <lud_nowhere_man(at)yahoo(dot)com>
To: ddurst(at)larubber(dot)com
Cc: PostgreSQL Mailing List <pgsql-sql(at)postgresql(dot)org>
Subject: Re: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
Date: 2003-01-22 09:53:11
Message-ID: 20030122095311.49903.qmail@web80313.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


--- David Durst <ddurst(at)larubber(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tomasz Myrta 2003-01-22 10:02:23 Re: optimal sql
Previous Message Michael Hostbaek 2003-01-22 08:54:54 optimal sql