Re: Foreign Key Columns And Indices

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Foreign Key Columns And Indices
Date: 2001-02-05 07:32:50
Message-ID: Pine.BSF.4.21.0102042330470.35188-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


On Mon, 5 Feb 2001, Christopher Kings-Lynne wrote:

> Just a quick question, when a column of a table is defined to be a foreign
> key, is it implicitly indexed, or does one still need to explicitly CREATE
> INDEX?

The foreign key columns are not currently implicitly indexed but you may
wish to index them if you're using a referential action other than no
action or restrict.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hannu Krosing 2001-02-05 07:38:30 Re: Like vs '=' bug with indexing
Previous Message Karel Zak 2001-02-05 07:02:49 Re: julian day function