Re: PK & FK & Index Questio

From: Rodrigo De León <rdeleonp(at)gmail(dot)com>
To: "L D" <lenardd(at)hotmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: PK & FK & Index Questio
Date: 2007-09-02 21:20:51
Message-ID: a55915760709021420i32247e2x64963dc025cbd25@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 9/2/07, L D <lenardd(at)hotmail(dot)com> wrote:
> Should I set the latter table's FK also to PK?

It's sane.

> If so, do I need to set an index on the FK even though it's also the primary key?

No need to do so.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Stefan Arentz 2007-09-03 11:22:15 Speeding up schema changes
Previous Message L D 2007-09-02 21:12:06 PK & FK & Index Question