Re: are foreign keys realized as indexes?

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: Felix Kater <fkater(at)googlemail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: are foreign keys realized as indexes?
Date: 2007-05-08 11:48:30
Message-ID: 4640638E.8050905@iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 08/05/2007 12:32, Felix Kater wrote:

> I like to keep my pg interface small: Can I replace foreign keys by
> using indexes somehow? (This is at least possible for primary key
> columns which can be replaced by suitable indexes.)

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

Ray.

---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
---------------------------------------------------------------

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Felix Kater 2007-05-08 12:14:54 Re: are foreign keys realized as indexes?
Previous Message Felix Kater 2007-05-08 11:32:18 are foreign keys realized as indexes?