Re: Foreign keys and indexes

From: Filip Rembiałkowski <plk(dot)zuber(at)gmail(dot)com>
To: "Marc Compte" <mcompte(at)sigte(dot)udg(dot)es>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Foreign keys and indexes
Date: 2007-06-05 13:08:34
Message-ID: 92869e660706050608v7675a65dr1d69aeb0ecf5f3ec@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2007/6/5, Marc Compte <mcompte(at)sigte(dot)udg(dot)es>:
> Dear list,
>
> This might be too basic for a question but I just couldn't find the
> answer so far.
>
> Does PostgreSQL create an implicit index also for foreign keys? or must
> I create it explicitly?

FK is just a constraint, you wil have to create indexes manually if
you need them.

--
Filip Rembiałkowski

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ranieri Mazili 2007-06-05 13:11:59 CREATE RULE with WHERE clause
Previous Message Chander Ganesan 2007-06-05 13:03:49 Re: High-availability