Re: are foreign keys realized as indexes? - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: are foreign keys realized as indexes?
Date
Msg-id 4640638E.8050905@iol.ie
Whole thread Raw
In response to are foreign keys realized as indexes?  (Felix Kater <fkater@googlemail.com>)
Responses Re: are foreign keys realized as indexes?
List 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@iol.ie
---------------------------------------------------------------

pgsql-general by date:

Previous
From: Felix Kater
Date:
Subject: are foreign keys realized as indexes?
Next
From: Felix Kater
Date:
Subject: Re: are foreign keys realized as indexes?