Re: Foreign keys and indexes

From: Michael Fuhr <mike(at)fuhr(dot)org>
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:20:31
Message-ID: 20070605132030.GA69925@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2007-06-05 13:22:32 Re: Encrypted column
Previous Message Richard Broersma Jr 2007-06-05 13:16:33 Re: Foreign keys and indexes