Re: are foreign keys realized as indexes?

From: Felix Kater <fkater(at)googlemail(dot)com>
To: rod(at)iol(dot)ie
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: are foreign keys realized as indexes?
Date: 2007-05-08 12:14:54
Message-ID: 20070508141454.312b178e.fkater@googlemail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 08 May 2007 12:48:30 +0100
Raymond O'Donnell <rod(at)iol(dot)ie> wrote:

> You can do that, but you'll lose the enforcement of referential
> integrity, which is what foreign keys give you.

If I get you right:

There is *no complete* substitute for foreign keys by using *indexes*
since I'd loose the referencial integrity (whereas for unique contraints
there *is* a full replacement using indexes)?

Felix

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2007-05-08 12:19:12 Re: are foreign keys realized as indexes?
Previous Message Raymond O'Donnell 2007-05-08 11:48:30 Re: are foreign keys realized as indexes?