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$ (view raw, whole thread or download thread mbox)
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


  • 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-2017 The PostgreSQL Global Development Group