Re: Foreign keys - Mailing list pgsql-novice

From Bruno Wolff III
Subject Re: Foreign keys
Date
Msg-id 20040827191622.GA456@wolff.to
Whole thread Raw
In response to Foreign keys  (Steve Tucknott <steve@retsol.co.uk>)
List pgsql-novice
On Fri, Aug 27, 2004 at 09:31:51 +0100,
  Steve Tucknott <steve@retsol.co.uk> wrote:
> PostGreSql 7.4.3
>
> Am I right in assuming that a foreign key on a table does not explicity
> create an index on that column on the foreign table? I can see via the
> \d on the table that the foreign key exists, but accessing the table on
> that column seems to use a sequential scan.

Do the data types match?

pgsql-novice by date:

Previous
From: Jeremy Semeiks
Date:
Subject: Re: Foreign keys
Next
From: Tom Lane
Date:
Subject: Re: Foreign keys