Re: are foreign keys realized as indexes?

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
---------------------------------------------------------------