Foreign key references to non-primary key columns - Mailing list pgsql-hackers

From Camm Maguire
Subject Foreign key references to non-primary key columns
Date
Msg-id 54zoia37zd.fsf@intech19.enhanced.com
Whole thread Raw
Responses Re: Foreign key references to non-primary key columns
List pgsql-hackers
Greetings!  I've noticed in the documentation that the sql standard
requires foreign keys to reference primary key/(or maybe just unique)
columns, but that postgresql does not enforce this.  Is this a feature
that is intended to persist, or a temporary deviation from the sql
standard?  The current postgresql behavior seems useful in cases where
one wants to update a foreign key to a value already in the original
table.  

Take care,
-- 
Camm Maguire                             camm@enhanced.com
==========================================================================
"The earth is but one country, and mankind its citizens."  --  Baha'u'llah


pgsql-hackers by date:

Previous
From: Camm Maguire
Date:
Subject: copy from stdin limits
Next
From: Alfred Perlstein
Date:
Subject: Re: Need help with phys backed shm segments (Postgresql+FreeBSD).