Re: Foreign Key Columns And Indices

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?

I don't think you can actually declare the column in the table as a
foreign key.  A foreign key is a column or columns in another table.  For
a single column in the other table I'm pretty sure that column must be
'not null' and 'unique'.  An index - other than to inforce uniqueness
(currently how it's done in PostgreSQL?) - has nothing to do with the
foreign key.  Being a mere mortal - not a demi-god of PostgreSQLness - this could be
an over simplification or totally out to lunch.


Rod
--