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

From Michael Fuhr
Subject Re: Foreign keys and indexes
Date
Msg-id 20070605132030.GA69925@winnie.fuhr.org
Whole thread Raw
In response to Foreign keys and indexes  (Marc Compte <mcompte@sigte.udg.es>)
List pgsql-general
On Tue, Jun 05, 2007 at 11:49:20AM +0200, Marc Compte wrote:
> Does PostgreSQL create an implicit index also for foreign keys? or must
> I create it explicitly?

PostgreSQL doesn't create an index on the referencing column(s) of
a foreign key constraint; if you want an index then you'll need to
create it yourself.

--
Michael Fuhr

pgsql-general by date:

Previous
From: Ragnar
Date:
Subject: Re: Foreign keys and indexes
Next
From: Ron Johnson
Date:
Subject: Re: Encrypted column