primary key and foreign key - Mailing list pgsql-admin

From Jessica Richard
Subject primary key and foreign key
Date
Msg-id 768150.12661.qm@web56410.mail.re3.yahoo.com
Whole thread Raw
Responses Re: primary key and foreign key  (Richard Broersma Jr <rabroersma@yahoo.com>)
List pgsql-admin
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?

Thanks.


Sick sense of humor? Visit Yahoo! TV's Comedy with an Edge to see what's on, when.

pgsql-admin by date:

Previous
From: "Igor Neyman"
Date:
Subject: Re: Searching in a string with index
Next
From: Richard Broersma Jr
Date:
Subject: Re: primary key and foreign key