Re: RI

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: RI
Date: 2010-06-24 03:59:56
Message-ID: hvul7s$e7f$1@reversiblemaps.ath.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On 2010-06-24, Jean-Yves F. Barbier <12ukwn(at)gmail(dot)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.

In response to

  • RI at 2010-06-24 03:19:12 from Jean-Yves F. Barbier

Responses

  • Re: RI at 2010-06-24 04:48:18 from Tom Lane

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2010-06-24 04:48:18 Re: RI
Previous Message Jean-Yves F. Barbier 2010-06-24 03:19:12 RI