Foreign key references to non-primary key columns

From: Camm Maguire <camm(at)enhanced(dot)com>
To: Ed Loehr <eloehr(at)austin(dot)rr(dot)com>
Cc: pghackers <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Foreign key references to non-primary key columns
Date: 2000-12-05 20:53:42
Message-ID: 54zoia37zd.fsf@intech19.enhanced.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)enhanced(dot)com
==========================================================================
"The earth is but one country, and mankind its citizens." -- Baha'u'llah

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mikheev, Vadim 2000-12-05 20:59:50 RE: foreign key check makes a big LOCK
Previous Message Camm Maguire 2000-12-05 20:50:51 copy from stdin limits