Re: Foreign Key Columns And Indices - Mailing list pgsql-hackers

From Stephan Szabo
Subject Re: Foreign Key Columns And Indices
Date
Msg-id Pine.BSF.4.21.0102042330470.35188-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Foreign Key Columns And Indices  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Responses Re: Foreign Key Columns And Indices  (Jan Wieck <janwieck@Yahoo.com>)
List 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.




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Like vs '=' bug with indexing
Next
From: Hannu Krosing
Date:
Subject: Re: Like vs '=' bug with indexing