Re: Foreign key - index - Mailing list pgsql-novice

From Josh Kupershmidt
Subject Re: Foreign key - index
Date
Msg-id AANLkTinQPWk=N_TY2Vfjosm8bJLSoOhN0QpVsU3O447s@mail.gmail.com
Whole thread Raw
In response to Foreign key - index  (Majid Azimi <majid.merkava@gmail.com>)
Responses Re: Foreign key - index
List pgsql-novice
On Sat, Dec 25, 2010 at 12:33 PM, Majid Azimi <majid.merkava@gmail.com> wrote:
> hi guys.
>
> Does adding a foriegn key, create an implicit index like adding unique and
> primary keys? or we should do it manually.

Creating a foreign key constraint will not create any additional
indexes on either the target table or the referencing table.

Josh

pgsql-novice by date:

Previous
From: Josh Kupershmidt
Date:
Subject: Fwd: pgstatspack version?
Next
From: Mladen Gogala
Date:
Subject: Re: Foreign key - index