Re: Creating a foreign key

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: "Campbell, Lance" <lance(at)uiuc(dot)edu>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Creating a foreign key
Date: 2008-05-08 17:00:14
Message-ID: 20080508100014.1ceaa1f9@jd-laptop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, 8 May 2008 11:52:50 -0500
"Campbell, Lance" <lance(at)uiuc(dot)edu> wrote:

> PostgreSQL: 8.2
>
>
>
> When you create a foreign key to a table is there an index that is
> created on the foreign key automatically?

No.

Joshua D. Drake

--
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Shaun Thomas 2008-05-08 17:18:59 Re: Creating a foreign key
Previous Message Campbell, Lance 2008-05-08 16:52:50 Creating a foreign key