Postgres Pro
Downloads
Home   >   mailing lists

Re: PK & FK & Index Questio - Mailing list pgsql-sql

From Rodrigo De León
Subject Re: PK & FK & Index Questio
Date
Msg-id a55915760709021420i32247e2x64963dc025cbd25@mail.gmail.com
Whole thread Raw
In response to PK & FK & Index Question  (L D <lenardd@hotmail.com>)
List pgsql-sql
Tree view 
On 9/2/07, L D <lenardd@hotmail.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.

pgsql-sql by date:

Previous
From: L D
Date:
Subject: PK & FK & Index Question
Next
From: "Stefan Arentz"
Date:
Subject: Speeding up schema changes