Re: primary key and foreign key - Mailing list pgsql-admin

From Richard Broersma Jr
Subject Re: primary key and foreign key
Date
Msg-id 219041.90797.qm@web31809.mail.mud.yahoo.com
Whole thread Raw
In response to primary key and foreign key  (Jessica Richard <rjessil@yahoo.com>)
List pgsql-admin
--- Jessica Richard <rjessil@yahoo.com> wrote:

> Just want to be very clear that:
>
> 1. adding a primary key will have an implicit index automatically on the column(s).
>
> 2. Adding a foreign key will NOT have an index created automatically, it only does the
> referencing work. If an index is needed on the F-key column, it has to be created, right?

Correct.

Regards,
Richard Broersma Jr.


pgsql-admin by date:

Previous
From: Jessica Richard
Date:
Subject: primary key and foreign key
Next
From: Tom Lane
Date:
Subject: Re: Localisation