Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

Next:From: Tom LaneDate: 2010-06-24 04:48:18
Subject: Re: RI
Previous:From: Jean-Yves F. BarbierDate: 2010-06-24 03:19:12
Subject: RI

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group