Re: Foreign keys and indexes - Mailing list pgsql-general

From Filip Rembiałkowski
Subject Re: Foreign keys and indexes
Date
Msg-id 92869e660706050608v7675a65dr1d69aeb0ecf5f3ec@mail.gmail.com
Whole thread Raw
In response to Foreign keys and indexes  (Marc Compte <mcompte@sigte.udg.es>)
List pgsql-general
2007/6/5, Marc Compte <mcompte@sigte.udg.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

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: COPY error
Next
From: Ranieri Mazili
Date:
Subject: CREATE RULE with WHERE clause