Foreign keys

From: Steve Tucknott <steve(at)retsol(dot)co(dot)uk>
To: PostGreSQL <pgsql-novice(at)postgresql(dot)org>
Subject: Foreign keys
Date: 2004-08-27 08:31:51
Message-ID: 1093595513.10455.15.camel@retsol1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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.

Regards,

Steve Tucknott

ReTSol Ltd

DDI: 01903 828769

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Katsaros Kwn/nos 2004-08-27 10:50:02 Storing a plan to disc...
Previous Message Noel Faux 2004-08-27 08:31:15 Re: Foreign keys