Re: [HACKERS] Foreign Key Columns And Indices

[Stephan Szabo]

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.