Re: RI - Mailing list pgsql-novice

From Jasen Betts
Subject Re: RI
Date
Msg-id hvul7s$e7f$1@reversiblemaps.ath.cx
Whole thread Raw
In response to RI  ("Jean-Yves F. Barbier" <12ukwn@gmail.com>)
Responses Re: RI  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
On 2010-06-24, Jean-Yves F. Barbier <12ukwn@gmail.com> wrote:
> Hi list,
>
> does a Referential Integrity toward a table also acts like an index, or
> am I obliged to create this index?

The RI does not create any indices.
There is no requirement to create an index.
In most cases creating an index at one or both ends or the reference
is a good idea.

pgsql-novice by date:

Previous
From: "Jean-Yves F. Barbier"
Date:
Subject: RI
Next
From: Tom Lane
Date:
Subject: Re: RI